Hi
attached some minor corrections, mainly completion of removal of
the "relation with OID ##### does not exist" item, and some URL corrections.
Ian Barwick
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.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
