From: Ian Barwick <barwick@gmx.net>
To: pgsql-docs@postgresql.org
Subject: FAQ corrections
Date: Fri, 12 Oct 2007 20:04:56 +0200
Message-ID: <200710122004.56432.barwick@gmx.net> (raw)
Hi
attached some minor corrections, mainly completion of removal of
the "relation with OID ##### does not exist" item, and some URL corrections.
Ian Barwick
Attachments:FAQ.html.cdiff (text/x-diff, 7.0K) download
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: barwick@gmx.net
Subject: Re: FAQ corrections
In-Reply-To: <200710122004.56432.barwick@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox