From 2e964aee757c1000590fc38c411ebdfbd66d37fe Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Fri, 11 Mar 2005 21:47:44 +0000 Subject: Here's the patch to fix a lot of markup errors in the HTML FAQs. Doesn't change content (at least not supposed to). Magnus Hagander --- doc/src/FAQ/FAQ.html | 36 +++++++++++++++++++----------------- 1 file changed, 19 insertions(+), 17 deletions(-) (limited to 'doc/src/FAQ/FAQ.html') diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index d328aa639a5..32ed55ac000 100644 --- a/doc/src/FAQ/FAQ.html +++ b/doc/src/FAQ/FAQ.html @@ -10,7 +10,7 @@ alink="#0000ff">

Frequently Asked Questions (FAQ) for PostgreSQL

-

Last updated: Thu Feb 24 19:33:07 EST 2005

+

Last updated: Fri Mar 11 16:42:06 EST 2005

Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -113,8 +113,9 @@ databases?
4.19) How do I return multiple rows or columns from a function?
- 4.20) Why do I get "missing oid" errors when - accessing temporary tables in PL/PgSQL functions?
+ 4.20) Why do I get "relation with OID ##### + does not exist" errors when accessing temporary tables in PL/PgSQL + functions?
4.21) What encryption options are available?
@@ -196,7 +197,7 @@ and Win2003. A prepackaged installer is available at http://pgfoundry.org/projects/pginstaller. MSDOS-based versions - of Windows (Win95, Win98, WinMe) can run PostgreSQL using Cygwin. + of Windows (Win95, Win98, WinMe) can run PostgreSQL using Cygwin.

There is also a Novell Netware 6 port at http://forge.novell.com, @@ -216,14 +217,14 @@ via email. The main web site to subscribe to the email lists is http://www.postgresql.org/community/lists/. The general - or bugs lists are a good place to start. + or bugs lists are a good place to start.

The major IRC channel is #postgresql on Freenode (irc.freenode.net). To connect you can use the Unix program irc -c '#postgresql' "$USER" irc.freenode.net or use any of the other popular IRC clients. A Spanish one also exists on the same network, (#postgresql-es), and a French one, - (#postgresqlfr). There is also a PostgreSQL channel on EFNet. + (#postgresqlfr). There is also a PostgreSQL channel on EFNet.

A list of commercial support companies is available at @@ -412,7 +413,7 @@ href="http://www.php.net">http://www.php.net) is an excellent interface.

-

For complex cases, many use the Perl DBD::Pg with CGI.pm or +

For complex cases, many use the Perl and DBD::Pg with CGI.pm or mod_perl.

2.3) Does PostgreSQL have a graphical user @@ -481,7 +482,7 @@
  • Use of Prepared queries
  • Use of ANALYZE to maintain accurate optimizer statistics
    • -
  • Regular use of VACUUM or pg_autovacuum +
  • Regular use of VACUUM or pg_autovacuum
  • Dropping of indexes during large data changes


    • @@ -608,7 +609,7 @@ SELECT time, use a cursor and FETCH.

    -

    To SELECT a random row, use: +

    To SELECT a random row, use:

         SELECT col
     FROM tab
@@ -642,7 +643,7 @@
     
    4.3) How do you change a column's data type?
    
 
     
    Changing the data type of a column can be done easily in 8.0
-    and later with ALTER TABLE ALTER COLUMN TYPE.
+    and later with ALTER TABLE ALTER COLUMN TYPE.
    
 
     
    In earlier releases, do this:
    
 
    @@ -660,7 +661,7 @@
 
     
    These are the limits:
    
 
    
-
+
    
@@ -730,7 +731,7 @@ table?
     used if the table is larger than a minimum size, and the query
     selects only a small percentage of the rows in the table. This is
     because the random disk access caused by an index scan can be
-    slower than a straight read through the table, or sequential scan. 
+    slower than a straight read through the table, or sequential scan. 
    To determine if an index should be used, PostgreSQL must have
     statistics about the table. These statistics are collected using
@@ -842,7 +843,7 @@ table?
    4.10) What is the difference between the
     various character types?
    
-
    
 
    Maximum size for a database?unlimited (32 TB databases
 exist)
    
 
    Maximum size for a table?32 TB
    unlimited
    
 
     
    unlimited
    
     
 
    
+
    
@@ -1056,10 +1057,11 @@ length
    It is easy using set-returning functions, 
     
-    http://techdocs.postgresql.org/guides/SetReturningFunctions.
+    http://techdocs.postgresql.org/guides/SetReturningFunctions
    .
 
-    
    4.20) Why do I get "missing oid" errors when
-    accessing temporary tables in PL/PgSQL functions?
    
+    
    4.20) Why do I get "relation with OID #####
+    does not exist" errors when accessing temporary tables in PL/PgSQL
+    functions?
    PL/PgSQL caches function scripts, and an unfortunate side effect
     is that if a PL/PgSQL function accesses a temporary table, and that
@@ -1080,7 +1082,7 @@ length
     pg_hba.conf, and the client sslmode must not be
     disable. (Note that it is also possible to use a third-party
     encrypted transport, such as stunnel or ssh, rather than PostgreSQL's
-    native SSL connections.)
+    native SSL connections.)
     
  • Database user passwords are automatically encrypted when stored in
     the system tables.
  • The server can run using an encrypted file system.
    • 
-- 
cgit v1.2.3


    
 
    TypeInternal NameNotes
    
 
    VARCHAR(n)varcharsize specifies maximum
 length, no padding