Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitbf673f2

Browse files
committed
Attached some minor corrections, mainly completion of removal of
the "relation with OID ##### does not exist" item, and some URLcorrections.Ian Barwick
1 parent106264c commitbf673f2

File tree

2 files changed

+20
-49
lines changed

2 files changed

+20
-49
lines changed

‎doc/FAQ

Lines changed: 10 additions & 24 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11

22
Frequently Asked Questions (FAQ) for PostgreSQL
33

4-
Last updated:Tue Oct9 16:13:00 EDT 2007
4+
Last updated:Fri Oct12 23:36:59 EDT 2007
55

66
Current maintainer: Bruce Momjian (bruce@momjian.us)
77

@@ -100,7 +100,7 @@
100100
developers spread throughout the world and communicating via the
101101
Internet. It is a community project and is not controlled by any
102102
company. To get involved, see the developer's FAQ at
103-
http://www.postgresql.org/files/documentation/faqs/FAQ_DEV.html
103+
http://www.postgresql.org/docs/faqs.FAQ_DEV.html
104104

105105
1.2) Who controls PostgreSQL?
106106

@@ -253,9 +253,9 @@
253253
http://www.commandprompt.com/ppbook/. There are a number of PostgreSQL
254254
books available for purchase. One of the most popular ones is by Korry
255255
Douglas. A list of book reviews can be found at
256-
http://techdocs.postgresql.org/techdocs/bookreviews.php. There is also
257-
a collection ofPostgreSQL technical articles at
258-
http://techdocs.postgresql.org/.
256+
http://www.postgresql.org/docs/books/. There is also a collection of
257+
PostgreSQL technical articles at
258+
http://www.postgresql.org/docs/techdocs.
259259

260260
The command line client program psql has some \d commands to show
261261
information about types, operators, functions, aggregates, etc. - use
@@ -265,12 +265,10 @@
265265

266266
1.11) How can I learn SQL?
267267

268-
First, consider the PostgreSQL-specific books mentioned above. Another
269-
one is "Teach Yourself SQL in 21 Days, Second Edition" at
270-
http://members.tripod.com/er4ebus/sql/index.htm. Many of our users
271-
like The Practical SQL Handbook, Bowman, Judith S., et al.,
272-
Addison-Wesley. Others like The Complete Reference SQL, Groff et al.,
273-
McGraw-Hill.
268+
First, consider the PostgreSQL-specific books mentioned above. Many of
269+
our users also like The Practical SQL Handbook, Bowman, Judith S., et
270+
al., Addison-Wesley. Others like The Complete Reference SQL, Groff et
271+
al., McGraw-Hill.
274272

275273
There are also many nice tutorials available online:
276274
* http://www.intermedia.net/support/sql/sqltut.shtm
@@ -790,19 +788,7 @@
790788
4.18) How do I return multiple rows or columns from a function?
791789

792790
It is easy using set-returning functions,
793-
http://www.postgresql.org/docs/techdocs.17
794-
.
795-
796-
4.19) Why do I get "relation with OID ##### does not exist" errors when
797-
accessing temporary tables in PL/PgSQL functions?
798-
799-
PL/PgSQL caches function scripts, and an unfortunate side effect is
800-
that if a PL/PgSQL function accesses a temporary table, and that table
801-
is later dropped and recreated, and the function called again, the
802-
function will fail because the cached function contents still point to
803-
the old temporary table. The solution is to use EXECUTE for temporary
804-
table access in PL/PgSQL. This will cause the query to be reparsed
805-
every time.
791+
http://www.postgresql.org/docs/techdocs.17.
806792

807793
4.19) What replication solutions are available?
808794

‎doc/src/FAQ/FAQ.html

Lines changed: 10 additions & 25 deletions
Original file line numberDiff line numberDiff line change
@@ -10,7 +10,7 @@
1010
alink="#0000ff">
1111
<H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1>
1212

13-
<P>Last updated:Tue Oct 9 16:13:00 EDT 2007</P>
13+
<P>Last updated:Fri Oct12 23:36:59 EDT 2007</P>
1414

1515
<P>Current maintainer: Bruce Momjian (<Ahref=
1616
"mailto:bruce@momjian.us">bruce@momjian.us</A>)
@@ -141,8 +141,8 @@ <H3 id="item1.1">1.1) What is PostgreSQL? How is it pronounced?</H3>
141141
developers spread throughout the world and communicating via the
142142
Internet. It is a community project and is not controlled by any
143143
company. To get involved, see the developer's FAQ at<Ahref=
144-
"http://www.postgresql.org/files/documentation/faqs/FAQ_DEV.html">
145-
http://www.postgresql.org/files/documentation/faqs/FAQ_DEV.html</A>
144+
"http://www.postgresql.org/docs/faqs.FAQ_DEV.html">
145+
http://www.postgresql.org/docs/faqs.FAQ_DEV.html</A>
146146
</P>
147147

148148
<H3id="item1.2">1.2) Who controls PostgreSQL?<BR></H3>
@@ -334,10 +334,10 @@ <H3 id="item1.10">1.10) What documentation is available?</H3>
334334
There are a number of PostgreSQL books available for purchase. One
335335
of the most popular ones is by Korry Douglas. A list of book reviews
336336
can be found at<Ahref=
337-
"http://techdocs.postgresql.org/techdocs/bookreviews.php">http://techdocs.postgresql.org/techdocs/bookreviews.php</A>.
337+
"http://www.postgresql.org/docs/books/">http://www.postgresql.org/docs/books/</A>.
338338
There is also a collection of PostgreSQL technical articles at<A
339339
href=
340-
"http://techdocs.postgresql.org/">http://techdocs.postgresql.org/</A>.</P>
340+
"http://www.postgresql.org/docs/techdocs">http://www.postgresql.org/docs/techdocs</A>.</P>
341341

342342
<P>The command line client program<I>psql</I> has some \d commands to show
343343
information about types, operators, functions, aggregates, etc. - use \? to
@@ -349,10 +349,7 @@ <H3 id="item1.11">1.11) How can I learn
349349
<SMALL>SQL</SMALL>?</H3>
350350

351351
<P>First, consider the PostgreSQL-specific books mentioned above.
352-
Another one is "Teach Yourself SQL in 21 Days, Second Edition"
353-
at<Ahref=
354-
"http://members.tripod.com/er4ebus/sql/index.htm">http://members.tripod.com/er4ebus/sql/index.htm</A>.
355-
Many of our users like<I>The Practical SQL Handbook</I>,
352+
Many of our users also like<I>The Practical SQL Handbook</I>,
356353
Bowman, Judith S., et al., Addison-Wesley. Others like<I>The
357354
Complete Reference SQL</I>, Groff et al., McGraw-Hill.</P>
358355

@@ -541,7 +538,7 @@ <H3 id="item3.3">3.3) How do I tune the database engine for
541538

542539
<DD>A number of<I>postgresql.conf</I> settings affect performance.
543540
For more details, see<ahref=
544-
"http://www.postgresql.org/docs/current/static/runtime.html">
541+
"http://www.postgresql.org/docs/current/static/runtime-config.html">
545542
Administration Guide/Server Run-time Environment/Run-time
546543
Configuration</a> for a full listing, and for commentary see<a
547544
href="http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html">
@@ -1042,19 +1039,7 @@ <H3 id="item4.18">4.18) How do I return multiple rows or
10421039

10431040
<P>It is easy using set-returning functions,
10441041
<ahref="http://www.postgresql.org/docs/techdocs.17">
1045-
http://www.postgresql.org/docs/techdocs.17</a></P>.
1046-
1047-
<H3id="item4.19">4.19) Why do I get "relation with OID #####
1048-
does not exist" errors when accessing temporary tables in PL/PgSQL
1049-
functions?</H3>
1050-
1051-
<P>PL/PgSQL caches function scripts, and an unfortunate side effect
1052-
is that if a PL/PgSQL function accesses a temporary table, and that
1053-
table is later dropped and recreated, and the function called again,
1054-
the function will fail because the cached function contents still
1055-
point to the old temporary table. The solution is to use
1056-
<SMALL>EXECUTE</SMALL> for temporary table access in PL/PgSQL. This
1057-
will cause the query to be reparsed every time.</P>
1042+
http://www.postgresql.org/docs/techdocs.17</a>.</P>
10581043

10591044
<H3id="item4.19">4.19) What replication solutions are available?
10601045
</H3>
@@ -1066,7 +1051,7 @@ <H3 id="item4.19">4.19) What replication solutions are available?
10661051
queries, while slaves can only accept read/<SMALL>SELECT</SMALL>
10671052
queries. The most popular freely available master-slave PostgreSQL
10681053
replication solution is<A
1069-
href="http://gborg.postgresql.org/project/slony1/projdisplay.php">
1054+
href="http://main.slony.info/">
10701055
Slony-I</A>.</P>
10711056

10721057
<P>Multi-master replication allows read/write queries to be sent to
@@ -1085,7 +1070,7 @@ <H3 id="item4.20">4.20) Why are my table and column names not
10851070
double-quotes around table or column names during table creation.
10861071
When double-quotes are used, table and column names (called
10871072
identifiers) are stored<a
1088-
href="http://www.postgresql.org/docs/current/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS">
1073+
href="http://www.postgresql.org/docs/current/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS">
10891074
case-sensitive</a>, meaning you must use double-quotes when
10901075
referencing the names in a query. Some interfaces, like pgAdmin,
10911076
automatically double-quote identifiers during table creation.

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp