diff options
| author | Bruce Momjian <bruce@momjian.us> | 2002-04-27 03:04:08 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2002-04-27 03:04:08 +0000 |
| commit | aafe72efb2d9a01db77bacf94b9b103042b5eb60 (patch) | |
| tree | 9394f93fe4b151a10e325576913b581eb08cdbc2 | |
| parent | 97b6e3f06f89cbc92f459089f34ca39818cfc20f (diff) | |
| download | postgresql-aafe72efb2d9a01db77bacf94b9b103042b5eb60.tar.gz postgresql-aafe72efb2d9a01db77bacf94b9b103042b5eb60.zip | |
Update DROP COLUMN example to use transactions and rollback-able DROP TABLE>
| -rw-r--r-- | doc/FAQ | 5 | ||||
| -rw-r--r-- | doc/src/FAQ/FAQ.html | 5 |
2 files changed, 8 insertions, 2 deletions
@@ -1,7 +1,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL - Last updated: Thu Apr 18 00:44:51 EDT 2002 + Last updated: Fri Apr 26 23:03:46 EDT 2002 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -637,11 +637,14 @@ 4.4) How do you remove a column from a table? We do not support ALTER TABLE DROP COLUMN, but do this: + BEGIN; + LOCK TABLE old_table; SELECT ... -- select all columns but the one you want to remove INTO TABLE new_table FROM old_table; DROP TABLE old_table; ALTER TABLE new_table RENAME TO old_table; + COMMIT; 4.5) What is the maximum size for a row, a table, and a database? diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index 8f0dbb11bbc..988aa3f968f 100644 --- a/doc/src/FAQ/FAQ.html +++ b/doc/src/FAQ/FAQ.html @@ -14,7 +14,7 @@ alink="#0000ff"> <H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1> - <P>Last updated: Thu Apr 18 00:44:51 EDT 2002</P> + <P>Last updated: Fri Apr 26 23:03:46 EDT 2002</P> <P>Current maintainer: Bruce Momjian (<A href= "mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR> @@ -827,11 +827,14 @@ <P>We do not support <SMALL>ALTER TABLE DROP COLUMN,</SMALL> but do this:</P> <PRE> + BEGIN; + LOCK TABLE old_table; SELECT ... -- select all columns but the one you want to remove INTO TABLE new_table FROM old_table; DROP TABLE old_table; ALTER TABLE new_table RENAME TO old_table; + COMMIT; </PRE> <H4><A name="4.5">4.5</A>) What is the maximum size for a row, a |