Frequently Asked Questions (FAQ) for PostgreSQL

Last updated:Fri Apr 2510:34:17 EDT 2008

Last updated:Wed Jun 2523:02:18 EDT 2008

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

PostgreSQL also runs natively on Microsoft Windows NT-based operating

systems like Win2000 SP4, WinXP, and Win2003. A prepackaged installer

is available at http://pgfoundry.org/projects/pginstaller. MSDOS-based

versions of Windows (Win95, Win98, WinMe) can run PostgreSQL using

Cygwin.

is available at http://www.postgresql.org/download/windows.

MSDOS-basedversions of Windows (Win95, Win98, WinMe) can run

PostgreSQL usingCygwin.

There is also a Novell Netware 6 port at http://forge.novell.com, and

an OS/2 (eComStation) version at

There is also a Novell Netware 6 port at

http://developer.novell.com/wiki/index.php/Postgresql, and an OS/2

(eComStation) version at

http://hobbes.nmsu.edu/cgi-bin/h-search?sh=1&button=Search&key=postgre

SQL&stype=all&sort=type&dir=%2F.

There are a large number of GUI Tools that are available for

PostgreSQL from both commercial and open source developers. A detailed

list can be found in the PostgreSQLCommunity Documentation

list can be found in theCommunity Guide toPostgreSQLGUI Tools.

_________________________________________________________________

Administrative Questions

4.18) How do I return multiple rows or columns from a function?

It is easy using set-returning functions,

http://www.postgresql.org/docs/techdocs.17.

http://wiki.postgresql.org/wiki/Return_more_than_one_row_of_data_from_

PL/pgSQL_functions.

4.19) Why do I get "relation with OID ##### does not exist" errors when

accessing temporary tables in PL/PgSQL functions?

alink="#0000ff">

<H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1>

<P>Last updated:Fri Apr 2510:34:17 EDT 2008</P>

<P>Last updated:Wed Jun 2523:02:18 EDT 2008</P>

<P>Current maintainer: Bruce Momjian (<Ahref=

"mailto:bruce@momjian.us">bruce@momjian.us</A>)

<P>PostgreSQL also runs natively on Microsoft Windows NT-based operating

systems like Win2000 SP4, WinXP, and Win2003. A prepackaged installer is

available at<ahref= "http://pgfoundry.org/projects/pginstaller">

http://pgfoundry.org/projects/pginstaller</a>. MSDOS-based versions

available at<ahref= "http://www.postgresql.org/download/windows">

http://www.postgresql.org/download/windows</a>. MSDOS-based versions

of Windows (Win95, Win98, WinMe) can run PostgreSQL using Cygwin.</P>

<p>There is also a Novell Netware 6 port at

<ahref="http://forge.novell.com">http://forge.novell.com</a>,

<ahref="http://developer.novell.com/wiki/index.php/Postgresql">http://developer.novell.com/wiki/index.php/Postgresql</a>,

and an OS/2 (eComStation) version at<ahref=

"http://hobbes.nmsu.edu/cgi-bin/h-search?sh=1&amp;button=Search&amp;key=postgreSQL&amp;stype=all&amp;sort=type&amp;dir=%2F">

http://hobbes.nmsu.edu/cgi-bin/h-search?sh=1&amp;button=Search&amp;key=postgreSQL&amp;stype=all&amp;sort=type&amp;dir=%2F</a>.</p>

<P>There are a large number of GUI Tools that are available for PostgreSQL

from both commercial and open source developers. A detailed list can be

found in the<Ahref="http://www.postgresql.org/docs/techdocs.54">

PostgreSQLCommunity Documentation</A></P>

found in the<Ahref="http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools">

Community Guide toPostgreSQLGUI Tools</A>.</P>

columns from a function?</H3>

<P>It is easy using set-returning functions,

<ahref="http://www.postgresql.org/docs/techdocs.17">

http://www.postgresql.org/docs/techdocs.17</a>.</P>

<ahref="http://wiki.postgresql.org/wiki/Return_more_than_one_row_of_data_from_PL/pgSQL_functions">

http://wiki.postgresql.org/wiki/Return_more_than_one_row_of_data_from_PL/pgSQL_functions</a>.</P>

<H3id="item4.19">4.19) Why do I get "relation with OID #####

does not exist" errors when accessing temporary tables in PL/PgSQL