Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 153F39F9DA8
	for <pgsql-docs-postgresql.org@postgresql.org>;
	Fri, 12 Oct 2007 15:28:30 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 05387-03 for <pgsql-docs-postgresql.org@postgresql.org>;
	Fri, 12 Oct 2007 15:28:25 -0300 (ADT)
X-Greylist: delayed 00:23:18.828636 by SQLgrey-1.7.5
Received: from p15140235.pureserver.info (sql-info.de [217.160.166.164])
	by postgresql.org (Postfix) with ESMTP id D74C19F9E4C
	for <pgsql-docs@postgresql.org>; Fri, 12 Oct 2007 15:28:24 -0300 (ADT)
Received: by p15140235.pureserver.info (Postfix, from userid 639)
	id 8BC2F3566; Fri, 12 Oct 2007 20:04:26 +0200 (CEST)
Received: from iwate.sql-info.de (p54BE4E11.dip.t-dialin.net [84.190.78.17])
	(using TLSv1 with cipher RC4-SHA (128/128 bits))
	(No client certificate requested)
	by p15140235.pureserver.info (Postfix) with ESMTP id 3F3B2331E
	for <pgsql-docs@postgresql.org>; Fri, 12 Oct 2007 20:04:21 +0200 (CEST)
From: Ian Barwick <barwick@gmx.net>
To: pgsql-docs@postgresql.org
Subject: FAQ corrections
Date: Fri, 12 Oct 2007 20:04:56 +0200
User-Agent: KMail/1.9.5
MIME-Version: 1.0
Content-Type: Multipart/Mixed;
  boundary="Boundary-00=_Id7DH0OaxjhWqGA"
Message-Id: <200710122004.56432.barwick@gmx.net>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200710/42
X-Sequence-Number: 4463

--Boundary-00=_Id7DH0OaxjhWqGA
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi

attached some minor corrections, mainly completion of removal of 
the  "relation with OID ##### does not exist" item, and some URL corrections.

Ian Barwick

--Boundary-00=_Id7DH0OaxjhWqGA
Content-Type: text/x-diff;
  charset="utf-8";
  name="FAQ.html.cdiff"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
	filename="FAQ.html.cdiff"

Index: FAQ.html
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/FAQ/FAQ.html,v
retrieving revision 1.394
diff -c -r1.394 FAQ.html
*** FAQ.html	9 Oct 2007 20:13:11 -0000	1.394
--- FAQ.html	12 Oct 2007 18:03:12 -0000
***************
*** 141,148 ****
      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>
      </P>
  
      <H3 id="item1.2">1.2) Who controls PostgreSQL?<BR></H3>
--- 141,148 ----
      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/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,343 ****
      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>.
      There is also a collection of PostgreSQL technical articles at <A
      href=
!     "http://techdocs.postgresql.org/">http://techdocs.postgresql.org/</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 
--- 334,343 ----
      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://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://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,358 ****
      <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>,
      Bowman, Judith S., et al., Addison-Wesley. Others like <I>The
      Complete Reference SQL</I>, Groff et al., McGraw-Hill.</P>
  
--- 349,355 ----
      <SMALL>SQL</SMALL>?</H3>
  
      <P>First, consider the PostgreSQL-specific books mentioned above.
!     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,547 ****
  
      <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">
      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">
--- 538,544 ----
  
      <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-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,1060 ****
  
      <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>
  
      <H3 id="item4.19">4.19) What replication solutions are available?
      </H3>
--- 1039,1045 ----
  
      <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) What replication solutions are available?
      </H3>
***************
*** 1066,1072 ****
      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">
      Slony-I</A>.</P>
  
      <P>Multi-master replication allows read/write queries to be sent to
--- 1051,1057 ----
      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://main.slony.info/">
      Slony-I</A>.</P>
  
      <P>Multi-master replication allows read/write queries to be sent to
***************
*** 1085,1091 ****
      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">
      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.
--- 1070,1076 ----
      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-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.

--Boundary-00=_Id7DH0OaxjhWqGA--