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 - 1.394
--- FAQ.html 12 Oct 2007 18:03:12 -
***
*** 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 http://www.postgresql.org/files/documentation/faqs/FAQ_DEV.html";>
! http://www.postgresql.org/files/documentation/faqs/FAQ_DEV.html
1.2) Who controls PostgreSQL?
--- 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 http://www.postgresql.org/docs/faqs.FAQ_DEV.html";>
! http://www.postgresql.org/docs/faqs.FAQ_DEV.html
1.2) Who controls PostgreSQL?
***
*** 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 http://techdocs.postgresql.org/techdocs/bookreviews.php";>http://techdocs.postgresql.org/techdocs/bookreviews.php.
There is also a collection of PostgreSQL technical articles at http://techdocs.postgresql.org/";>http://techdocs.postgresql.org/.
The command line client program psql 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 http://www.postgresql.org/docs/books/";>http://www.postgresql.org/docs/books/.
There is also a collection of PostgreSQL technical articles at http://www.postgresql.org/docs/techdocs";>http://www.postgresql.org/docs/techdocs.
The command line client program psql has some \d commands to show
information about types, operators, functions, aggregates, etc. - use \? to
***
*** 349,358
SQL?
First, consider the PostgreSQL-specific books mentioned above.
! Another one is "Teach Yourself SQL in 21 Days, Second Edition"
! at http://members.tripod.com/er4ebus/sql/index.htm";>http://members.tripod.com/er4ebus/sql/index.htm.
! Many of our users like The Practical SQL Handbook,
Bowman, Judith S., et al., Addison-Wesley. Others like The
Complete Reference SQL, Groff et al., McGraw-Hill.
--- 349,355
SQL?
First, consider the PostgreSQL-specific books mentioned above.
! Many of our users also like The Practical SQL Handbook,
Bowman, Judith S., et al., Addison-Wesley. Others like The
Complete Reference SQL, Groff et al., McGraw-Hill.
***
*** 541,547
A number of postgresql.conf settings affect performance.
For more details, see http://www.postgresql.org/docs/current/static/runtime.html";>
Administration Guide/Server Run-time Environment/Run-time
Configuration for a full listing, and for commentary see http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html";>
--- 538,544
A number of postgresql.conf settings affect performance.
For more details, see http://www.postgresql.org/docs/current/static/runtime-config.html";>
Administration Guide/Server Run-time Environment/Run-time
Configuration for a full listing, and for commentary see http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html";>
***
*** 1042,1060
It is easy using set-returning functions,
http://www.postgresql.org/docs/techdocs.17";>
! http://www.postgresql.org/docs/techdocs.17.
!
! 4.19) 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
! 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
! EXECUTE for temporary table access in PL/PgSQL. This
! will cause the query to be reparsed every time.
4.19) What replication solutions are available?
--- 1039,1045
It is easy using set-returning functions,
http://www.postgresql.org/docs/techdocs.17";>
! http://www.postgresql.org/docs/techdocs.17.
