From barwick@gmx.net Fri Oct 12 18:28:30 2007 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 153F39F9DA8 for ; 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 ; 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 ; 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 ; Fri, 12 Oct 2007 20:04:21 +0200 (CEST) From: Ian Barwick 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 ! 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

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. There is also a collection of PostgreSQL technical articles at 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/. There is also a collection of PostgreSQL technical articles at 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. ! 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 Administration Guide/Server Run-time Environment/Run-time Configuration for a full listing, and for commentary see --- 538,544 ----
A number of postgresql.conf settings affect performance. For more details, see Administration Guide/Server Run-time Environment/Run-time Configuration for a full listing, and for commentary see *************** *** 1042,1060 ****

It is easy using set-returning functions, ! 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.

4.19) What replication solutions are available?

*************** *** 1066,1072 **** queries, while slaves can only accept read/SELECT queries. The most popular freely available master-slave PostgreSQL replication solution is Slony-I.

Multi-master replication allows read/write queries to be sent to --- 1051,1057 ---- queries, while slaves can only accept read/SELECT queries. The most popular freely available master-slave PostgreSQL replication solution is Slony-I.

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 case-sensitive, 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 case-sensitive, 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-- From bruce@momjian.us Sat Oct 13 03:38:01 2007 Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id D666C9FA650 for ; Sat, 13 Oct 2007 00:38:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 23420-04 for ; Sat, 13 Oct 2007 00:37:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from momjian.us (momjian.us [70.90.9.53]) by postgresql.org (Postfix) with ESMTP id DDC6C9FBCD0 for ; Sat, 13 Oct 2007 00:37:19 -0300 (ADT) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id l9D3bHR27858; Fri, 12 Oct 2007 23:37:17 -0400 (EDT) From: Bruce Momjian Message-Id: <200710130337.l9D3bHR27858@momjian.us> Subject: Re: FAQ corrections In-Reply-To: <200710122004.56432.barwick@gmx.net> To: Ian Barwick Date: Fri, 12 Oct 2007 23:37:17 -0400 (EDT) CC: pgsql-docs@postgresql.org X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/43 X-Sequence-Number: 4464 Patch applied. Thanks. --------------------------------------------------------------------------- Ian Barwick wrote: > Hi > > attached some minor corrections, mainly completion of removal of > the "relation with OID ##### does not exist" item, and some URL corrections. > > Ian Barwick [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq -- Bruce Momjian http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + From xzilla@users.sourceforge.net Tue Oct 16 19:01:17 2007 Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id ADEAC9FBD27 for ; Tue, 16 Oct 2007 16:01:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 72346-02-6 for ; Tue, 16 Oct 2007 16:01:04 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from vms044pub.verizon.net (vms044pub.verizon.net [206.46.252.44]) by postgresql.org (Postfix) with ESMTP id B4FF09FBDF9 for ; Tue, 16 Oct 2007 16:00:42 -0300 (ADT) Received: from new-host.home ([71.179.23.138]) by vms044.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0JQ0005C9OFL8PQ0@vms044.mailsrvcs.net> for pgsql-docs@postgresql.org; Tue, 16 Oct 2007 13:23:46 -0500 (CDT) Date: Tue, 16 Oct 2007 14:23:28 -0400 From: Robert Treat Subject: Re: FAQ corrections In-reply-to: <200710122004.56432.barwick@gmx.net> To: pgsql-docs@postgresql.org Cc: Ian Barwick Message-id: <200710161423.28655.xzilla@users.sourceforge.net> MIME-version: 1.0 Content-type: text/plain; charset=iso-8859-15 Content-transfer-encoding: 7bit Content-disposition: inline References: <200710122004.56432.barwick@gmx.net> User-Agent: KMail/1.9.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/58 X-Sequence-Number: 4479 On Friday 12 October 2007 14:04, Ian Barwick wrote: > Hi > > attached some minor corrections, mainly completion of removal of > the "relation with OID ##### does not exist" item, and some URL > corrections. > I'm curious why this was removed. We still get this question a bit on irc and there aren't any more appropriate answers for any released version than what the FAQ contained... -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL From bruce@momjian.us Tue Oct 16 19:46:13 2007 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 20BA69FBA82 for ; Tue, 16 Oct 2007 16:46:13 -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 65340-01-6 for ; Tue, 16 Oct 2007 16:46:07 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from momjian.us (momjian.us [70.90.9.53]) by postgresql.org (Postfix) with ESMTP id 377589FBA90 for ; Tue, 16 Oct 2007 16:46:07 -0300 (ADT) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id l9GJk6b06643; Tue, 16 Oct 2007 15:46:06 -0400 (EDT) From: Bruce Momjian Message-Id: <200710161946.l9GJk6b06643@momjian.us> Subject: Re: FAQ corrections In-Reply-To: <200710161423.28655.xzilla@users.sourceforge.net> To: Robert Treat Date: Tue, 16 Oct 2007 15:46:06 -0400 (EDT) CC: pgsql-docs@postgresql.org, Ian Barwick X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/61 X-Sequence-Number: 4482 Robert Treat wrote: > On Friday 12 October 2007 14:04, Ian Barwick wrote: > > Hi > > > > attached some minor corrections, mainly completion of removal of > > the "relation with OID ##### does not exist" item, and some URL > > corrections. > > > > I'm curious why this was removed. We still get this question a bit on irc and > there aren't any more appropriate answers for any released version than what > the FAQ contained... The FAQ will match the release it goes with or we could just delay its removal until after 8.3 is in major circulation and say it only applies to pre-8.3. -- Bruce Momjian http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + From xzilla@users.sourceforge.net Tue Oct 16 22:04:25 2007 Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 0D8369FB713 for ; Tue, 16 Oct 2007 19:04:25 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 52784-06 for ; Tue, 16 Oct 2007 19:04:15 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from vms044pub.verizon.net (vms044pub.verizon.net [206.46.252.44]) by postgresql.org (Postfix) with ESMTP id 0ED0B9FB6ED for ; Tue, 16 Oct 2007 19:04:19 -0300 (ADT) Received: from new-host.home ([71.179.23.138]) by vms044.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0JQ000MO3YLBSLW1@vms044.mailsrvcs.net> for pgsql-docs@postgresql.org; Tue, 16 Oct 2007 17:03:15 -0500 (CDT) Date: Tue, 16 Oct 2007 18:02:53 -0400 From: Robert Treat Subject: Re: FAQ corrections In-reply-to: <200710161946.l9GJk6b06643@momjian.us> To: Bruce Momjian Cc: pgsql-docs@postgresql.org, Ian Barwick Message-id: <200710161802.54084.xzilla@users.sourceforge.net> MIME-version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 7bit Content-disposition: inline References: <200710161946.l9GJk6b06643@momjian.us> User-Agent: KMail/1.9.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/62 X-Sequence-Number: 4483 On Tuesday 16 October 2007 15:46, Bruce Momjian wrote: > Robert Treat wrote: > > On Friday 12 October 2007 14:04, Ian Barwick wrote: > > > Hi > > > > > > attached some minor corrections, mainly completion of removal of > > > the "relation with OID ##### does not exist" item, and some URL > > > corrections. > > > > I'm curious why this was removed. We still get this question a bit on irc > > and there aren't any more appropriate answers for any released version > > than what the FAQ contained... > > The FAQ will match the release it goes with or we could just delay its > removal until after 8.3 is in major circulation and say it only applies > to pre-8.3. I think it should remain, with an addition that this problem should be resolved as of PostgreSQL 8.3. Hard to say exactly when, but I would think it would be at least untill 8.3 is released, and probably better would be 6 months or so later, when (hopefully) people stop asking about this. IMHO. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL From barwick@gmx.net Wed Oct 17 12:27:39 2007 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 48E609FB9CE for ; Wed, 17 Oct 2007 09:27:39 -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 72024-08 for ; Wed, 17 Oct 2007 09:27:33 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from p15140235.pureserver.info (sql-info.de [217.160.166.164]) by postgresql.org (Postfix) with ESMTP id 8417B9FBB6F for ; Wed, 17 Oct 2007 09:27:33 -0300 (ADT) Received: by p15140235.pureserver.info (Postfix, from userid 639) id 653203B81; Wed, 17 Oct 2007 14:26:53 +0200 (CEST) Received: from iwate.sql-info.de (p54BE5CE3.dip.t-dialin.net [84.190.92.227]) (using TLSv1 with cipher RC4-SHA (128/128 bits)) (No client certificate requested) by p15140235.pureserver.info (Postfix) with ESMTP id 345923B80; Wed, 17 Oct 2007 14:26:50 +0200 (CEST) From: Ian Barwick To: pgsql-docs@postgresql.org Subject: Re: FAQ corrections Date: Wed, 17 Oct 2007 14:27:49 +0200 User-Agent: KMail/1.9.5 Cc: Robert Treat , Bruce Momjian References: <200710161946.l9GJk6b06643@momjian.us> <200710161802.54084.xzilla@users.sourceforge.net> In-Reply-To: <200710161802.54084.xzilla@users.sourceforge.net> MIME-Version: 1.0 Content-Type: Multipart/Mixed; boundary="Boundary-00=_G/fFHaqrkUP3tjj" Message-Id: <200710171427.50421.barwick@gmx.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/63 X-Sequence-Number: 4484 --Boundary-00=_G/fFHaqrkUP3tjj Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline On Wednesday 17 October 2007 00:02, Robert Treat wrote: > On Tuesday 16 October 2007 15:46, Bruce Momjian wrote: > > Robert Treat wrote: > > > On Friday 12 October 2007 14:04, Ian Barwick wrote: > > > > Hi > > > > > > > > attached some minor corrections, mainly completion of removal of > > > > the "relation with OID ##### does not exist" item, and some URL > > > > corrections. > > > > > > I'm curious why this was removed. We still get this question a bit on > > > irc and there aren't any more appropriate answers for any released > > > version than what the FAQ contained... > > > > The FAQ will match the release it goes with or we could just delay its > > removal until after 8.3 is in major circulation and say it only applies > > to pre-8.3. > > I think it should remain, with an addition that this problem should be > resolved as of PostgreSQL 8.3. Hard to say exactly when, but I would think > it would be at least untill 8.3 is released, and probably better would be 6 > months or so later, when (hopefully) people stop asking about this. IMHO. Sounds sensible. (I removed it while going through checking for broken links etc., and the section numbering didn't match the contents; checking against CVS it appeared the intention of Revision 1.393 was to remove this item, cf. http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/FAQ.html#rev1.393 ). Attached is an updated FAQ patch which re-includes this item and a note that it's been resolved in 8.3. Ian Barwick --Boundary-00=_G/fFHaqrkUP3tjj Content-Type: text/x-diff; charset="iso-8859-1"; 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.395 diff -r1.395 FAQ.html 117,118c117,121 < 4.19) What replication solutions are available?
< 4.20) Why are my table and column names not --- > 4.19) Why do I get "relation with OID ##### > does not exist" errors when accessing temporary tables in PL/PgSQL > functions?
> 4.20) What replication solutions are available?
> 4.21) Why are my table and column names no 1044c1047,1061 <

4.19) What replication solutions are available? --- >

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.

> >

This problem has been resolved in PostgreSQL 8.3.

> >

4.20) What replication solutions are available? 1066c1083 <

4.20) Why are my table and column names not --- >

4.21) Why are my table and column names not --Boundary-00=_G/fFHaqrkUP3tjj-- From bruce@momjian.us Wed Oct 17 17:35:08 2007 Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id B94FF9FBD1F for ; Wed, 17 Oct 2007 14:35:08 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 25009-09-2 for ; Wed, 17 Oct 2007 14:34:44 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from momjian.us (momjian.us [70.90.9.53]) by postgresql.org (Postfix) with ESMTP id 79F969FBD34 for ; Wed, 17 Oct 2007 14:35:02 -0300 (ADT) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id l9HHZ0L03551; Wed, 17 Oct 2007 13:35:00 -0400 (EDT) From: Bruce Momjian Message-Id: <200710171735.l9HHZ0L03551@momjian.us> Subject: Re: FAQ corrections In-Reply-To: <200710171427.50421.barwick@gmx.net> To: Ian Barwick Date: Wed, 17 Oct 2007 13:35:00 -0400 (EDT) CC: pgsql-docs@postgresql.org, Robert Treat X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/64 X-Sequence-Number: 4485 OK, item re-added. Thanks. --------------------------------------------------------------------------- Ian Barwick wrote: > On Wednesday 17 October 2007 00:02, Robert Treat wrote: > > On Tuesday 16 October 2007 15:46, Bruce Momjian wrote: > > > Robert Treat wrote: > > > > On Friday 12 October 2007 14:04, Ian Barwick wrote: > > > > > Hi > > > > > > > > > > attached some minor corrections, mainly completion of removal of > > > > > the "relation with OID ##### does not exist" item, and some URL > > > > > corrections. > > > > > > > > I'm curious why this was removed. We still get this question a bit on > > > > irc and there aren't any more appropriate answers for any released > > > > version than what the FAQ contained... > > > > > > The FAQ will match the release it goes with or we could just delay its > > > removal until after 8.3 is in major circulation and say it only applies > > > to pre-8.3. > > > > I think it should remain, with an addition that this problem should be > > resolved as of PostgreSQL 8.3. Hard to say exactly when, but I would think > > it would be at least untill 8.3 is released, and probably better would be 6 > > months or so later, when (hopefully) people stop asking about this. IMHO. > > Sounds sensible. (I removed it while going through checking for broken links > etc., and the section numbering didn't match the contents; checking against > CVS it appeared the intention of Revision 1.393 was to remove this item, cf. > http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/FAQ.html#rev1.393 > ). > > Attached is an updated FAQ patch which re-includes this item and a note that > it's been resolved in 8.3. > > > Ian Barwick [ Attachment, skipping... ] -- Bruce Momjian http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +