Skip to content

Commit 6d54070

Browse files
bmomjianbmomjian
committed
Update FAQ.
1 parent eed55d9 commit 6d54070

File tree

2 files changed

+46
-66
lines changed

2 files changed

+46
-66
lines changed

‎doc/FAQ

Lines changed: 25 additions & 35 deletions
Original file line numberDiff line numberDiff line change
@@ -1,24 +1,15 @@
11

22
Frequently Asked Questions (FAQ) for PostgreSQL
33

4-
Last updated: Fri Jun 2 11:32:13 EDT 2000
4+
Last updated: Wed Jul 26 13:33:21 EDT 2000
55

66
Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
77

88
The most recent version of this document can be viewed at
99
http://www.PostgreSQL.org/docs/faq-english.html.
1010

11-
Linux-specific questions are answered in
12-
http://www.PostgreSQL.org/docs/faq-linux.html.
13-
14-
HPUX-specific questions are answered in
15-
http://www.PostgreSQL.org/docs/faq-hpux.html.
16-
17-
Solaris-specific questions are answered in
18-
http://www.PostgreSQL.org/docs/faq-solaris.html.
19-
20-
Irix-specific questions are answered in
21-
http://www.PostgreSQL.org/docs/faq-irix.html.
11+
Platform-specific questions are answered at
12+
http://www.PostgreSQL.org/docs/.
2213
_________________________________________________________________
2314

2415
General Questions
@@ -86,7 +77,7 @@
8677
4.11) What is an R-tree index?
8778
4.12) What is Genetic Query Optimization?
8879
4.13) How do I do regular expression searches and case-insensitive
89-
regular expression searching?
80+
regular expression searches?
9081
4.14) In a query, how do I detect if a field is NULL?
9182
4.15) What is the difference between the various character types?
9283
4.16.1) How do I create a serial/auto-incrementing field?
@@ -127,11 +118,11 @@
127118
replaces the PostQuel query language with an extended subset of SQL.
128119
PostgreSQL is free and the complete source is available.
129120

130-
PostgreSQL development is being performed by a team of Internet
131-
developers who all subscribe to the PostgreSQL development mailing
132-
list. The current coordinator is Marc G. Fournier
133-
(scrappy@PostgreSQL.org). (See below on how to join). This team is now
134-
responsible for all development of PostgreSQL.
121+
PostgreSQL development is performed by a team of Internet developers
122+
who all subscribe to the PostgreSQL development mailing list. The
123+
current coordinator is Marc G. Fournier (scrappy@PostgreSQL.org). (See
124+
below on how to join). This team is now responsible for all
125+
development of PostgreSQL.
135126

136127
The authors of PostgreSQL 1.01 were Andrew Yu and Jolly Chen. Many
137128
others have contributed to the porting, testing, debugging and
@@ -214,8 +205,8 @@
214205

215206
1.6) Where can I get support?
216207

217-
There is no official support for PostgreSQL from the University of
218-
California, Berkeley. It is maintained through volunteer effort.
208+
There is no support for PostgreSQL from the University of California,
209+
Berkeley. It is maintained through volunteer effort.
219210

220211
The main mailing list is: pgsql-general@PostgreSQL.org. It is
221212
available for discussion of matters pertaining to PostgreSQL. To
@@ -414,8 +405,7 @@
414405
For web integration, PHP is an excellent interface. It is at
415406
http://www.php.net
416407

417-
PHP is great for simple stuff, but for more complex cases, many use
418-
the perl interface and CGI.pm.
408+
For complex cases, many use the perl interface and CGI.pm.
419409

420410
A WWW gateway based on WDB using perl can be downloaded from
421411
http://www.eol.ists.ca/~dunlop/wdb-p95
@@ -433,15 +423,15 @@
433423
2.4) What languages are available to communicate with PostgreSQL?
434424

435425
We have:
436-
* C(libpq)
437-
* C++(libpq++)
438-
* Embedded C(ecpg)
439-
* Java(jdbc)
440-
* Perl(perl5)
441-
* ODBC(odbc)
442-
* Python(PyGreSQL)
443-
* TCL(libpgtcl)
444-
* C Easy API(libpgeasy)
426+
* C (libpq)
427+
* C++ (libpq++)
428+
* Embedded C (ecpg)
429+
* Java (jdbc)
430+
* Perl (perl5)
431+
* ODBC (odbc)
432+
* Python (PyGreSQL)
433+
* TCL (libpgtcl)
434+
* C Easy API (libpgeasy)
445435
* Embedded HTML (PHP from http://www.php.net)
446436
_________________________________________________________________
447437

@@ -632,9 +622,9 @@
632622
requires more space than the backend's -S parameter allows, then
633623
temporary files are created to hold the extra data.
634624

635-
The temp files should be deleted automatically, but might not if a
636-
backend crashes during a sort. If you have no backends running at the
637-
time, it is safe to delete the pg_tempNNN.NN files.
625+
The temporary files should be deleted automatically, but might not if
626+
a backend crashes during a sort. If you have no backends running at
627+
the time, it is safe to delete the pg_tempNNN.NN files.
638628
_________________________________________________________________
639629

640630
Operational Questions
@@ -796,7 +786,7 @@ Maximum number of indexes on a table? unlimited
796786
join queries through non-exhaustive search.
797787

798788
4.13) How do I do regular expression searches and case-insensitive regular
799-
expression searching?
789+
expression searches?
800790

801791
The ~ operator does regular-expression matching, and ~* does
802792
case-insensitive regular-expression matching. There is no

‎doc/src/FAQ/FAQ.html

Lines changed: 21 additions & 31 deletions
Original file line numberDiff line numberDiff line change
@@ -7,7 +7,7 @@ <H1>
77
Frequently Asked Questions (FAQ) for PostgreSQL
88
</H1>
99
<P>
10-
Last updated: Fri Jun 2 11:32:13 EDT 2000
10+
Last updated: Wed Jul 26 13:33:21 EDT 2000
1111
<P>
1212
Current maintainer: Bruce Momjian (<A
1313
HREF="mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR><P>
@@ -16,17 +16,8 @@ <H1>
1616
<A HREF="http://www.Postgresql.org/docs/faq-english.html">
1717
http://www.PostgreSQL.org/docs/faq-english.html</A>.<P>
1818

19-
Linux-specific questions are answered in <A
20-
HREF="http://www.PostgreSQL.org/docs/faq-linux.html">http://www.PostgreSQL.org/docs/faq-linux.html</A>.<P>
21-
22-
HPUX-specific questions are answered in <A
23-
HREF="http://www.PostgreSQL.org/docs/faq-hpux.html">http://www.PostgreSQL.org/docs/faq-hpux.html</A>.<P>
24-
25-
Solaris-specific questions are answered in <A
26-
HREF="http://www.PostgreSQL.org/docs/faq-solaris.html">http://www.PostgreSQL.org/docs/faq-solaris.html</A>.<P>
27-
28-
Irix-specific questions are answered in <A
29-
HREF="http://www.PostgreSQL.org/docs/faq-irix.html">http://www.PostgreSQL.org/docs/faq-irix.html</A>.<P>
19+
Platform-specific questions are answered at <A
20+
HREF="http://www.PostgreSQL.org/docs/">http://www.PostgreSQL.org/docs/</A>.<P>
3021

3122
<HR><P>
3223

@@ -115,7 +106,7 @@ <H2><CENTER>Operational Questions</CENTER></H2>
115106
<A HREF="#4.12">4.12</A>) What is Genetic Query Optimization?<BR>
116107

117108
<A HREF="#4.13">4.13</A>) How do I do regular expression searches
118-
and case-insensitive regular expression searching?<BR>
109+
and case-insensitive regular expression searches?<BR>
119110
<A HREF="#4.14">4.14</A>) In a query, how do I detect if a field
120111
is NULL?<BR>
121112
<A HREF="#4.15">4.15</A>) What is the difference between the
@@ -169,7 +160,7 @@ <H4><A
169160
PostQuel query language with an extended subset of SQL. PostgreSQL is
170161
free and the complete source is available.<P>
171162

172-
PostgreSQL development is being performed by a team of Internet
163+
PostgreSQL development is performed by a team of Internet
173164
developers who all subscribe to the PostgreSQL development mailing list.
174165
The current coordinator is Marc G. Fournier (<A
175166
HREF="mailto:scrappy@PostgreSQL.org">scrappy@PostgreSQL.org</A>). (See
@@ -252,13 +243,13 @@ <H4><A NAME="1.3">1.3</A>) What Unix platforms does PostgreSQL run
252243

253244
<H4><A NAME="1.4">1.4</A>) What non-unix ports are available?</H4><P>
254245

255-
It is possible to compile the libpq C library, psql, and other
246+
It is possible to compile the <I>libpq</I> C library, psql, and other
256247
interfaces and binaries to run on MS Windows platforms. In this case,
257248
the client is running on MS Windows, and communicates via TCP/IP to a
258249
server running on one of our supported Unix platforms.<P>
259250

260251
A file <I>win31.mak</I> is included in the distribution for making a
261-
Win32 libpq library and psql.<P>
252+
Win32 <I>libpq</I> library and psql.<P>
262253

263254
The database server is now working on Windows NT using the Cygnus
264255
Unix/NT porting library. See <I>pgsql/doc/FAQ_NT</I> in the distribution.<P>
@@ -272,7 +263,7 @@ <H4><A NAME="1.5">1.5</A>) Where can I get PostgreSQL?</H4><P>
272263

273264
<H4><A NAME="1.6">1.6</A>) Where can I get support?</H4><P>
274265

275-
There is no official support for PostgreSQL from the University of
266+
There is no support for PostgreSQL from the University of
276267
California, Berkeley. It is maintained through volunteer effort.<P>
277268

278269
The main mailing list is: <A
@@ -531,8 +522,7 @@ <H4><A NAME="2.2">2.2</A>) What tools are available for hooking
531522
For web integration, PHP is an excellent interface. It is at
532523
<A HREF="http://www.php.net">http://www.php.net</A><P>
533524

534-
PHP is great for simple stuff, but for more complex cases, many
535-
use the perl interface and CGI.pm.<P>
525+
For complex cases, many use the perl interface and CGI.pm.<P>
536526

537527
A WWW gateway based on WDB using perl can be downloaded from <A
538528
HREF="http://www.eol.ists.ca/~dunlop/wdb-p95">http://www.eol.ists.ca/~dunlop/wdb-p95</A>
@@ -553,15 +543,15 @@ <H4><A NAME="2.4">2.4</A>) What languages are available to
553543

554544
We have:
555545
<UL>
556-
<LI>C(libpq)
557-
<LI>C++(libpq++)
558-
<LI>Embedded C(ecpg)
559-
<LI>Java(jdbc)
560-
<LI>Perl(perl5)
561-
<LI>ODBC(odbc)
562-
<LI>Python(PyGreSQL)
563-
<LI>TCL(libpgtcl)
564-
<LI>C Easy API(libpgeasy)
546+
<LI>C (libpq)
547+
<LI>C++ (libpq++)
548+
<LI>Embedded C (ecpg)
549+
<LI>Java (jdbc)
550+
<LI>Perl (perl5)
551+
<LI>ODBC (odbc)
552+
<LI>Python (PyGreSQL)
553+
<LI>TCL (libpgtcl)
554+
<LI>C Easy API (libpgeasy)
565555
<LI>Embedded HTML (<A HREF="http://www.php.net">PHP from http://www.php.net</A>)
566556
</UL><P>
567557

@@ -783,7 +773,7 @@ <H4><A NAME="3.13">3.13</A>) What are the <I>pg_sorttempNNN.NN</I> files in my
783773
the sort requires more space than the backend's <I>-S</I> parameter allows,
784774
then temporary files are created to hold the extra data.<P>
785775

786-
The temp files should be deleted automatically, but might not if a backend
776+
The temporary files should be deleted automatically, but might not if a backend
787777
crashes during a sort. If you have no backends running at the time,
788778
it is safe to delete the pg_tempNNN.NN files.<P>
789779

@@ -977,7 +967,7 @@ <H4><A NAME="4.12">4.12</A>) What is Genetic Query
977967
non-exhaustive search.<P>
978968

979969
<H4><A NAME="4.13">4.13</A>) How do I do regular expression searches and
980-
case-insensitive regular expression searching?</H4><P>
970+
case-insensitive regular expression searches?</H4><P>
981971

982972
The <I>~</I> operator does regular-expression matching, and <I>~*</I>
983973
does case-insensitive regular-expression matching. There is no
@@ -1231,7 +1221,7 @@ <H4><A NAME="5.3">5.3</A>) How can I contribute some nifty new types and
12311221
functions to PostgreSQL?</H4><P>
12321222

12331223

1234-
Send your extensions to the pgsql-hackers mailing list, and they will
1224+
Send your extensions to the <I>pgsql-hackers</I> mailing list, and they will
12351225
eventually end up in the <I>contrib/</I> subdirectory.<P>
12361226

12371227

0 commit comments

Comments
 (0)