diff options
Diffstat (limited to 'doc')
| -rw-r--r-- | doc/FAQ | 18 | ||||
| -rw-r--r-- | doc/FAQ_DEV | 2 | ||||
| -rw-r--r-- | doc/FAQ_MSWIN | 18 | ||||
| -rw-r--r-- | doc/bug.template | 4 | ||||
| -rw-r--r-- | doc/src/FAQ/FAQ.html | 10 | ||||
| -rw-r--r-- | doc/src/FAQ/FAQ_DEV.html | 4 |
6 files changed, 26 insertions, 30 deletions
@@ -1,7 +1,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL - Last updated: Sat Nov 15 23:41:03 EST 2003 + Last updated: Sat Nov 29 23:54:03 EST 2003 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -253,7 +253,7 @@ 1.7) What is the latest release? - The latest release of PostgreSQL is version 7.3.4. + The latest release of PostgreSQL is version 7.4. We plan to have major releases every six to eight months. @@ -430,11 +430,10 @@ Yes, there are several graphical interfaces to PostgreSQL available. These include PgAccess http://www.pgaccess.org), PgAdmin III - (http://www.pgadmin.org, Win32-only), RHDB Admin - (http://sources.redhat.com/rhdb/ ) and Rekall ( - http://www.thekompany.com/products/rekall/, proprietary). There is - also PHPPgAdmin ( http://phppgadmin.sourceforge.net/ ), a web-based - interface to PostgreSQL. + (http://www.pgadmin.org, RHDB Admin (http://sources.redhat.com/rhdb/ ) + and Rekall ( http://www.thekompany.com/products/rekall/, proprietary). + There is also PHPPgAdmin ( http://phppgadmin.sourceforge.net/ ), a + web-based interface to PostgreSQL. See http://techdocs.postgresql.org/guides/GUITools for a more detailed list. @@ -879,8 +878,8 @@ BYTEA bytea variable-length byte array (null-byte safe) 4.15.1) How do I create a serial/auto-incrementing field? - PostgreSQL supports a SERIAL data type. It auto-creates a sequence and - index on the column. For example, this: + PostgreSQL supports a SERIAL data type. It auto-creates a sequence. + For example, this: CREATE TABLE person ( id SERIAL, name TEXT @@ -892,7 +891,6 @@ BYTEA bytea variable-length byte array (null-byte safe) id INT4 NOT NULL DEFAULT nextval('person_id_seq'), name TEXT ); - CREATE UNIQUE INDEX person_id_key ON person ( id ); See the create_sequence manual page for more information about sequences. You can also use each row's OID field as a unique value. diff --git a/doc/FAQ_DEV b/doc/FAQ_DEV index 65d478471a4..cbed280b6cb 100644 --- a/doc/FAQ_DEV +++ b/doc/FAQ_DEV @@ -1,7 +1,7 @@ Developer's Frequently Asked Questions (FAQ) for PostgreSQL - Last updated: Wed Oct 29 21:40:18 EST 2003 + Last updated: Sat Nov 29 23:56:43 EST 2003 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) diff --git a/doc/FAQ_MSWIN b/doc/FAQ_MSWIN index 12a13af68e5..34cf67b71c3 100644 --- a/doc/FAQ_MSWIN +++ b/doc/FAQ_MSWIN @@ -1,9 +1,9 @@ How to install PostgreSQL on Windows ==================================== -$Date: 2003/11/14 18:07:48 $ +$Date: 2003/12/13 16:57:36 $ -PostgreSQL requires the appropriate subset of Cygwin DLLs to be +PostgreSQL requires the appropriate subset of Cygwin DLLs to be installed in order that it functions under Windows. This document assumes that you do not have Cygwin already installed @@ -18,7 +18,7 @@ adjust these instructions accordingly. 2. Proceed through the Cygwin install wizard. Choose 'Install from Internet', specify a Local Package Directory and choose a mirror site that's close to you. Answer the other installer questions - appropriately for your configuration. + appropriately for your configuration. When you come to the point of choosing which packages to install, expand the 'Database' section and click 'Skip' next to PostgreSQL @@ -28,15 +28,15 @@ adjust these instructions accordingly. 3. Once the download and install process is complete, open a Cygwin shell and do the following for a basic installation: - 3a. Start ipc-daemon2 for shared memory support. To do this, - enter the command "ipc-daemon2 &". This program - needs to be running anytime you start the PostgreSQL server + 3a. Start ipc-daemon2 for shared memory support. To do this, + enter the command "ipc-daemon2 &". This program + needs to be running anytime you start the PostgreSQL server (postmaster) or initialize a database (initdb). 3b. Use the initdb command to create a new database cluster. An example command would be: - initdb -D /usr/local/pgsql/data -W -E LATIN1 + initdb -D /usr/local/pgsql/data -W -E LATIN1 Which will create a cluster in the /usr/local/pgsql/data directory, will prompt for a superuser password and will @@ -45,7 +45,7 @@ adjust these instructions accordingly. 3c. Start up the postmaster. Use a command similar to the following: - postmaster -D /usr/local/pgsql/data + postmaster -D /usr/local/pgsql/data This will start the postmaster, and if successful you will see some initial log entries, and an entry "LOG: database @@ -88,7 +88,7 @@ Known issues 2. "make check" can generate spurious regression test failures due to overflowing the listen() backlog queue which causes connection - refused errors or hangs. You can limit the number of connections + refused errors or hangs. You can limit the number of connections using the MAX_CONNECTIONS option thus: make MAX_CONNECTIONS=5 check diff --git a/doc/bug.template b/doc/bug.template index eed3099ed41..7ce4c6b958d 100644 --- a/doc/bug.template +++ b/doc/bug.template @@ -25,9 +25,9 @@ System Configuration --------------------- Architecture (example: Intel Pentium) : - Operating System (example: Linux 2.0.26 ELF) : + Operating System (example: Linux 2.4.18) : - PostgreSQL version (example: PostgreSQL-7.4): PostgreSQL-7.4 + PostgreSQL version (example: PostgreSQL-7.4.1): PostgreSQL-7.4.1 Compiler used (example: gcc 2.95.2) : diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index 52b11dd0eb5..764d2d82d09 100644 --- a/doc/src/FAQ/FAQ.html +++ b/doc/src/FAQ/FAQ.html @@ -10,7 +10,7 @@ alink="#0000ff"> <H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1> - <P>Last updated: Sat Nov 15 23:41:03 EST 2003</P> + <P>Last updated: Sat Nov 29 23:54:03 EST 2003</P> <P>Current maintainer: Bruce Momjian (<A href= "mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR> @@ -326,7 +326,7 @@ <H4><A name="1.7">1.7</A>) What is the latest release?</H4> - <P>The latest release of PostgreSQL is version 7.3.4.</P> + <P>The latest release of PostgreSQL is version 7.4.</P> <P>We plan to have major releases every six to eight months.</P> @@ -554,8 +554,7 @@ <P>Yes, there are several graphical interfaces to PostgreSQL available. These include PgAccess <a href="http://www.pgaccess.org"> http://www.pgaccess.org</a>), PgAdmin III (<a - href="http://www.pgadmin.org">http://www.pgadmin.org</a>, - Win32-only), RHDB Admin (<a + href="http://www.pgadmin.org">http://www.pgadmin.org</a>, RHDB Admin (<a href="http://sources.redhat.com/rhdb/">http://sources.redhat.com/rhdb/ </a>) and Rekall (<a href="http://www.thekompany.com/products/rekall/"> http://www.thekompany.com/products/rekall/</a>, proprietary). There is @@ -1102,7 +1101,7 @@ BYTEA bytea variable-length byte array (null-byte safe) serial/auto-incrementing field?</H4> <P>PostgreSQL supports a <SMALL>SERIAL</SMALL> data type. It - auto-creates a sequence and index on the column. For example, + auto-creates a sequence. For example, this:</P> <PRE> CREATE TABLE person ( @@ -1118,7 +1117,6 @@ BYTEA bytea variable-length byte array (null-byte safe) id INT4 NOT NULL DEFAULT nextval('person_id_seq'), name TEXT ); - CREATE UNIQUE INDEX person_id_key ON person ( id ); </PRE> See the <I>create_sequence</I> manual page for more information diff --git a/doc/src/FAQ/FAQ_DEV.html b/doc/src/FAQ/FAQ_DEV.html index 64037ff5cda..538d4d1b08d 100644 --- a/doc/src/FAQ/FAQ_DEV.html +++ b/doc/src/FAQ/FAQ_DEV.html @@ -12,7 +12,7 @@ <H1>Developer's Frequently Asked Questions (FAQ) for PostgreSQL</H1> - <P>Last updated: Wed Oct 29 21:40:18 EST 2003</P> + <P>Last updated: Sat Nov 29 23:56:43 EST 2003</P> <P>Current maintainer: Bruce Momjian (<A href= "mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR> @@ -89,7 +89,7 @@ <B>What development environment (OS, system, compilers, etc) is required to develop code?</B> - <P><A href="http://developers.postgresql.org">Developers Corner</A> on the + <P><A href="http://developer.postgresql.org">Developers Corner</A> on the website has links to this information. The distribution tarball itself includes all the extra tools and documents that go beyond a good Unix-like development environment. In general, a modern unix |