pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedFAQ corrections
7+ messages / 3 participants
[nested] [flat]
* FAQ corrections
@ 2007-10-12 18:04 Ian Barwick <barwick@gmx.net>
0 siblings, 2 replies; 7+ messages in thread
From: Ian Barwick @ 2007-10-12 18:04 UTC (permalink / raw)
To: pgsql-docs
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.
* Re: FAQ corrections
@ 2007-10-13 03:37 Bruce Momjian <bruce@momjian.us>
parent: Ian Barwick <barwick@gmx.net>
1 sibling, 0 replies; 7+ messages in thread
From: Bruce Momjian @ 2007-10-13 03:37 UTC (permalink / raw)
To: Ian Barwick <barwick@gmx.net>; +Cc: pgsql-docs
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 <bruce@momjian.us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: FAQ corrections
@ 2007-10-16 18:23 Robert Treat <xzilla@users.sourceforge.net>
parent: Ian Barwick <barwick@gmx.net>
1 sibling, 1 reply; 7+ messages in thread
From: Robert Treat @ 2007-10-16 18:23 UTC (permalink / raw)
To: pgsql-docs; +Cc: Ian Barwick <barwick@gmx.net>
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: FAQ corrections
@ 2007-10-16 19:46 Bruce Momjian <bruce@momjian.us>
parent: Robert Treat <xzilla@users.sourceforge.net>
0 siblings, 1 reply; 7+ messages in thread
From: Bruce Momjian @ 2007-10-16 19:46 UTC (permalink / raw)
To: Robert Treat <xzilla@users.sourceforge.net>; +Cc: pgsql-docs@postgresql.org, Ian Barwick <barwick@gmx.net>
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 <bruce@momjian.us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: FAQ corrections
@ 2007-10-16 22:02 Robert Treat <xzilla@users.sourceforge.net>
parent: Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 7+ messages in thread
From: Robert Treat @ 2007-10-16 22:02 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: pgsql-docs@postgresql.org, Ian Barwick <barwick@gmx.net>
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: FAQ corrections
@ 2007-10-17 12:27 Ian Barwick <barwick@gmx.net>
parent: Robert Treat <xzilla@users.sourceforge.net>
0 siblings, 1 reply; 7+ messages in thread
From: Ian Barwick @ 2007-10-17 12:27 UTC (permalink / raw)
To: pgsql-docs; +Cc: Robert Treat <xzilla@users.sourceforge.net>; Bruce Momjian <bruce@momjian.us>
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
Attachments:
FAQ.html.cdiff (text/x-diff, 1.7K) download
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
< <A href="#item4.20">4.19</A>) What replication solutions are available?<BR>
< <A href="#item4.21">4.20</A>) Why are my table and column names not
---
> <A href="#item4.19">4.19</A>) Why do I get "relation with OID #####
> does not exist" errors when accessing temporary tables in PL/PgSQL
> functions?<BR>
> <A href="#item4.20">4.20</A>) What replication solutions are available?<BR>
> <A href="#item4.21">4.21</A>) Why are my table and column names no
1044c1047,1061
< <H3 id="item4.19">4.19) What replication solutions are available?
---
> <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>
>
> <P>This problem has been resolved in PostgreSQL 8.3.</P>
>
> <H3 id="item4.20">4.20) What replication solutions are available?
1066c1083
< <H3 id="item4.20">4.20) Why are my table and column names not
---
> <H3 id="item4.21">4.21) Why are my table and column names not
* Re: FAQ corrections
@ 2007-10-17 17:35 Bruce Momjian <bruce@momjian.us>
parent: Ian Barwick <barwick@gmx.net>
0 siblings, 0 replies; 7+ messages in thread
From: Bruce Momjian @ 2007-10-17 17:35 UTC (permalink / raw)
To: Ian Barwick <barwick@gmx.net>; +Cc: pgsql-docs@postgresql.org, Robert Treat <xzilla@users.sourceforge.net>
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 <bruce@momjian.us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2007-10-17 17:35 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-10-12 18:04 FAQ corrections Ian Barwick <barwick@gmx.net>
2007-10-13 03:37 ` Bruce Momjian <bruce@momjian.us>
2007-10-16 18:23 ` Robert Treat <xzilla@users.sourceforge.net>
2007-10-16 19:46 ` Bruce Momjian <bruce@momjian.us>
2007-10-16 22:02 ` Robert Treat <xzilla@users.sourceforge.net>
2007-10-17 12:27 ` Ian Barwick <barwick@gmx.net>
2007-10-17 17:35 ` Bruce Momjian <bruce@momjian.us>
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