From e5f2155a7852c1b486b40a91150d1fea8b76d292 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Fri, 6 Jun 2003 22:20:40 +0000 Subject: [PATCH] Update FAQ from Ian Barwick. --- doc/FAQ | 11 ++++++----- doc/src/FAQ/FAQ.html | 12 ++++++------ 2 files changed, 12 insertions(+), 11 deletions(-) diff --git a/doc/FAQ b/doc/FAQ index 32b52e1ba3..4668f662d0 100644 --- a/doc/FAQ +++ b/doc/FAQ @@ -1,7 +1,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL - Last updated: Fri May 30 22:24:56 EDT 2003 + Last updated: Fri Jun 6 18:20:23 EDT 2003 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -252,7 +252,7 @@ 1.7) What is the latest release? - The latest release of PostgreSQL is version 7.3.2. + The latest release of PostgreSQL is version 7.3.3. We plan to have major releases every four months. @@ -265,8 +265,9 @@ There are two PostgreSQL books available online at http://www.PostgreSQL.org/docs/awbook.html and http://www.commandprompt.com/ppbook/. There is a list of PostgreSQL - books available for purchase at http://www.ca.PostgreSQL.org/books/. - There is also a collection of PostgreSQL technical articles at + books available for purchase at + http://techdocs.PostgreSQL.org/techdocs/bookreviews.php. There is also + a collection of PostgreSQL technical articles at http://techdocs.PostgreSQL.org/. psql has some nice \d commands to show information about types, @@ -671,7 +672,7 @@ BEGIN; ALTER TABLE tab ADD COLUMN new_col new_data_type; UPDATE tab SET new_col = CAST(old_col AS new_data_type); - ALTER TABLE DROP COLUMN old_col; + ALTER TABLE tab DROP COLUMN old_col; COMMIT; You might then want to do VACUUM FULL tab to reclaim the disk space diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index 1ba98d6ac0..b579275355 100644 --- a/doc/src/FAQ/FAQ.html +++ b/doc/src/FAQ/FAQ.html @@ -10,7 +10,7 @@ alink="#0000ff">

Frequently Asked Questions (FAQ) for PostgreSQL

-

Last updated: Fri May 30 22:24:56 EDT 2003

+

Last updated: Fri Jun 6 18:20:23 EDT 2003

Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
@@ -323,7 +323,7 @@

1.7) What is the latest release?

-

The latest release of PostgreSQL is version 7.3.2.

+

The latest release of PostgreSQL is version 7.3.3.

We plan to have major releases every four months.

@@ -340,7 +340,7 @@ "http://www.commandprompt.com/ppbook/">http://www.commandprompt.com/ppbook/. There is a list of PostgreSQL books available for purchase at http://www.ca.PostgreSQL.org/books/. + "http://techdocs.postgresql.org/techdocs/bookreviews.php">http://techdocs.PostgreSQL.org/techdocs/bookreviews.php. There is also a collection of PostgreSQL technical articles at http://techdocs.PostgreSQL.org/.

@@ -505,7 +505,7 @@

Also, if you have a success story about PostgreSQL, please submit it to our advocacy site at - http://advocacy.postgresql.org. + http://advocacy.postgresql.org.

User Client Questions

@@ -612,7 +612,7 @@ postmaster. For most systems, with default numbers of buffers and processes, you need a minimum of ~1 MB. See the PostgreSQL + "http://www.PostgreSQL.org/docs/view.php?version=current&idoc=1&file=kernel-resources.html">PostgreSQL Administrator's Guide for more detailed information about shared memory and semaphores.

@@ -856,7 +856,7 @@ BEGIN; ALTER TABLE tab ADD COLUMN new_col new_data_type; UPDATE tab SET new_col = CAST(old_col AS new_data_type); - ALTER TABLE DROP COLUMN old_col; + ALTER TABLE tab DROP COLUMN old_col; COMMIT;

You might then want to do VACUUM FULL tab to reclaim the -- 2.11.0