1010alink ="#0000ff ">
1111< H1 > Frequently Asked Questions (FAQ) for PostgreSQL</ H1 >
1212
13- < P > Last updated:Mon Mar 17 11:32:59 EST 2003</ P >
13+ < P > Last updated:Tue Apr 22 14:02:41 EDT 2003</ P >
1414
1515< P > Current maintainer: Bruce Momjian (< A href =
1616 "mailto:pgman@candle.pha.pa.us "> pgman@candle.pha.pa.us</ A > )< BR >
@@ -21,7 +21,7 @@ <H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1>
2121 "http://www.PostgreSQL.org/docs/faqs/FAQ.html "> http://www.PostgreSQL.org/docs/faqs/FAQ.html</ A > .</ P >
2222
2323< P > Platform-specific questions are answered at< A href =
24- "http://www.PostgreSQL.org/users-lounge/ docs/index.html "> http://www.PostgreSQL.org/docs/index.html</ A > .</ P >
24+ "http://www.PostgreSQL.org/docs/index.html "> http://www.PostgreSQL.org/docs/index.html</ A > .</ P >
2525< HR >
2626
2727< H2 align ="center "> General Questions</ H2 >
@@ -245,11 +245,16 @@ <H4><A name="1.4">1.4</A>) What non-Unix ports are available?</H4>
245245< P > The database server can run on Windows NT and Win2k using
246246 Cygwin, the Cygnus Unix/NT porting library. See
247247< I > pgsql/doc/FAQ_MSWIN</ I > in the distribution or the MS Windows FAQ
248- at< A href ="http://www.PostgreSQL.org/docs/faqs/faq-mswin.html ">
249- http://www.PostgreSQL.org/docs/faqs/faq-mswin.html </ A > .</ P >
248+ at< A href ="http://www.PostgreSQL.org/docs/faqs/text/FAQ_MSWIN ">
249+ http://www.PostgreSQL.org/docs/faqs/text/FAQ_MSWIN </ A > .</ P >
250250
251251< p > A native port to MS Win NT/2000/XP is currently being worked
252- on.</ p >
252+ on. For more details on the current status of PostgreSQL on Windows see
253+ < a href ="http://techdocs.postgresql.org/guides/Windows ">
254+ http://techdocs.postgresql.org/guides/Windows</ a > .</ p >
255+
256+ < p > There is also a Novell Netware 6 port at
257+ < a href ="http://forge.novell.com "> http://forge.novell.com</ a > .</ p >
253258
254259< H4 > < A name ="1.5 "> 1.5</ A > ) Where can I get PostgreSQL?</ H4 >
255260
@@ -309,8 +314,8 @@ <H4><A name="1.6">1.6</A>) Where can I get support?</H4>
309314< A href ="http://www.PostgreSQL.org "> http://www.PostgreSQL.org</ A >
310315</ BLOCKQUOTE >
311316
312- < P > There is also an IRC channel on EFNet, channel
313- < I > #PostgreSQL</ I > . I use the Unix command< CODE > irc -c
317+ < P > There is also an IRC channel on EFNet and OpenProjects,
318+ channel < I > #PostgreSQL</ I > . I use the Unix command< CODE > irc -c
314319 '#PostgreSQL' "$USER" irc.phoenix.net.</ CODE > </ P >
315320
316321< P > A list of commercial support companies is available at< A href =
@@ -326,8 +331,8 @@ <H4><A name="1.8">1.8</A>) What documentation is available?</H4>
326331
327332< P > Several manuals, manual pages, and some small test examples are
328333 included in the distribution. See the< I > /doc</ I > directory. You
329- can also browse themanual online at< A href =
330- "http://www.ca. PostgreSQL.org/users-lounge/ docs/ "> http://www.ca. PostgreSQL.org/users-lounge/ docs/ </ A > .</ P >
334+ can also browse themanuals online at< A href =
335+ "http://www.PostgreSQL.org/docs "> http://www.PostgreSQL.org/docs</ A > .</ P >
331336
332337< P > There are two PostgreSQL books available online at< A href =
333338 "http://www.PostgreSQL.org/docs/awbook.html "> http://www.PostgreSQL.org/docs/awbook.html</ A >
@@ -602,7 +607,7 @@ <H4><A name="3.3">3.3</A>) When I try to start <I>postmaster</I>, I
602607< I > postmaster</ I > . For most systems, with default numbers of
603608 buffers and processes, you need a minimum of ~1 MB. See the< A
604609href =
605- "http://www.postgresql .org/idocs/index .php?kernel-resources.html "> PostgreSQL
610+ "http://www.PostgreSQL .org/docs/view .php?version=current&idoc=1&file= kernel-resources.html "> PostgreSQL
606611 Administrator's Guide</ A > for more detailed information about
607612 shared memory and semaphores.</ P >
608613
@@ -1342,11 +1347,10 @@ <H4><A name="4.24">4.24</A>) How do I perform queries using
13421347< H4 > < A name ="4.25 "> 4.25</ A > ) How do I return multiple rows or
13431348 columns from a function?</ H4 >
13441349
1345- < P > You can return result sets from PL/pgSQL functions using
1346- < I > refcursors</ I > . See< A href =
1347- "http://www.PostgreSQL.org/idocs/index.php?plpgsql-cursors.html ">
1348- http://www.PostgreSQL.org/idocs/index.php?plpgsql-cursors.html</ A > ,
1349- section 23.7.3.3.</ P >
1350+ < P > In 7.3, you can easily return multiple rows or columns from a
1351+ function,
1352+ < a href ="http://techdocs.postgresql.org/guides/SetReturningFunctions ">
1353+ http://techdocs.postgresql.org/guides/SetReturningFunctions</ a > .
13501354
13511355< H4 > < A name ="4.26 "> 4.26</ A > ) Why can't I reliably create/drop
13521356 temporary tables in PL/PgSQL functions?</ H4 >