From bf673f2525fe4fa086f3ae5f276d52e626fc9d77 Mon Sep 17 00:00:00 2001
From: Bruce Momjian
Date: Sat, 13 Oct 2007 03:37:12 +0000
Subject: Attached some minor corrections, mainly completion of removal of the 
 "relation with OID ##### does not exist" item, and some URL corrections.

Ian Barwick
---
 doc/src/FAQ/FAQ.html | 35 ++++++++++-------------------------
 1 file changed, 10 insertions(+), 25 deletions(-)

(limited to 'doc/src')

diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html
index e829f083147..38baf49798b 100644
--- a/doc/src/FAQ/FAQ.html
+++ b/doc/src/FAQ/FAQ.html
@@ -10,7 +10,7 @@
   alink="#0000ff">
     <H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1>
 
-    <P>Last updated: Tue Oct  9 16:13:00 EDT 2007</P>
+    <P>Last updated: Fri Oct 12 23:36:59 EDT 2007</P>
 
     <P>Current maintainer: Bruce Momjian (<A href=
     "mailto:bruce@momjian.us">bruce@momjian.us</A>)
@@ -141,8 +141,8 @@
     developers spread throughout the world and communicating via the
     Internet. It is a community project and is not controlled by any
     company. To get involved, see the developer's FAQ at <A href=
-    "http://www.postgresql.org/files/documentation/faqs/FAQ_DEV.html">
-    http://www.postgresql.org/files/documentation/faqs/FAQ_DEV.html</A>
+    "http://www.postgresql.org/docs/faqs.FAQ_DEV.html">
+    http://www.postgresql.org/docs/faqs.FAQ_DEV.html</A>
     </P>
 
     <H3 id="item1.2">1.2) Who controls PostgreSQL?<BR></H3>
@@ -334,10 +334,10 @@
     There are a number of PostgreSQL books available for purchase.  One
     of the most popular ones is by Korry Douglas.  A list of book reviews
     can be found at <A href=
-    "http://techdocs.postgresql.org/techdocs/bookreviews.php">http://techdocs.postgresql.org/techdocs/bookreviews.php</A>.
+    "http://www.postgresql.org/docs/books/">http://www.postgresql.org/docs/books/</A>.
     There is also a collection of PostgreSQL technical articles at <A
     href=
-    "http://techdocs.postgresql.org/">http://techdocs.postgresql.org/</A>.</P>
+    "http://www.postgresql.org/docs/techdocs">http://www.postgresql.org/docs/techdocs</A>.</P>
 
     <P>The command line client program <I>psql</I> has some \d commands to show
     information about types, operators, functions, aggregates, etc. - use \? to 
@@ -349,10 +349,7 @@
     <SMALL>SQL</SMALL>?</H3>
 
     <P>First, consider the PostgreSQL-specific books mentioned above.
-    Another one is "Teach Yourself SQL in 21 Days, Second Edition"
-    at <A href=
-    "http://members.tripod.com/er4ebus/sql/index.htm">http://members.tripod.com/er4ebus/sql/index.htm</A>.
-    Many of our users like <I>The Practical SQL Handbook</I>,
+    Many of our users also like <I>The Practical SQL Handbook</I>,
     Bowman, Judith S., et al., Addison-Wesley. Others like <I>The
     Complete Reference SQL</I>, Groff et al., McGraw-Hill.</P>
 
@@ -541,7 +538,7 @@
 
     <DD>A number of <I>postgresql.conf</I> settings affect performance.
     For more details, see <a href=
-    "http://www.postgresql.org/docs/current/static/runtime.html">
+    "http://www.postgresql.org/docs/current/static/runtime-config.html">
     Administration Guide/Server Run-time Environment/Run-time
     Configuration</a> for a full listing, and for commentary see <a
     href="http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html">
@@ -1042,19 +1039,7 @@ length</TD></TR>
 
     <P>It is easy using set-returning functions, 
     <a href="http://www.postgresql.org/docs/techdocs.17">
-    http://www.postgresql.org/docs/techdocs.17</a></P>.
-
-    <H3 id="item4.19">4.19) Why do I get "relation with OID #####
-    does not exist" errors when accessing temporary tables in PL/PgSQL
-    functions?</H3>
-
-    <P>PL/PgSQL caches function scripts, and an unfortunate side effect
-    is that if a PL/PgSQL function accesses a temporary table, and that
-    table is later dropped and recreated, and the function called again,
-    the function will fail because the cached function contents still
-    point to the old temporary table. The solution is to use
-    <SMALL>EXECUTE</SMALL> for temporary table access in PL/PgSQL. This
-    will cause the query to be reparsed every time.</P>
+    http://www.postgresql.org/docs/techdocs.17</a>.</P>
 
     <H3 id="item4.19">4.19) What replication solutions are available?
     </H3>
@@ -1066,7 +1051,7 @@ length</TD></TR>
     queries, while slaves can only accept read/<SMALL>SELECT</SMALL>
     queries. The most popular freely available master-slave PostgreSQL
     replication solution is <A
-    href="http://gborg.postgresql.org/project/slony1/projdisplay.php">
+    href="http://main.slony.info/">
     Slony-I</A>.</P>
 
     <P>Multi-master replication allows read/write queries to be sent to
@@ -1085,7 +1070,7 @@ length</TD></TR>
     double-quotes around table or column names during table creation.
     When double-quotes are used, table and column names (called
     identifiers) are stored <a
-    href="http://www.postgresql.org/docs/current/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS">
+    href="http://www.postgresql.org/docs/current/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS">
     case-sensitive</a>, meaning you must use double-quotes when
     referencing the names in a query.  Some interfaces, like pgAdmin,
     automatically double-quote identifiers during table creation.
-- 
cgit v1.2.3