diff options
| author | Bruce Momjian | 2003-06-06 22:20:40 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2003-06-06 22:20:40 +0000 |
| commit | e5f2155a7852c1b486b40a91150d1fea8b76d292 (patch) | |
| tree | 18f25f814ff58d25c6ba89b7a9ba651121a7c507 /doc/FAQ | |
| parent | b4b3e340e3e996e47a7766e8ce1de05b798e699c (diff) | |
Update FAQ from Ian Barwick.
Diffstat (limited to 'doc/FAQ')
| -rw-r--r-- | doc/FAQ | 11 |
1 files changed, 6 insertions, 5 deletions
@@ -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 |