From 24614a988005a0811198458fc934b87375582168 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Tue, 23 Mar 2004 19:35:17 +0000 Subject: Upgrade ALTER TABLE DROP COLUMN so that it can drop an OID column, and remove separate implementation of ALTER TABLE SET WITHOUT OIDS in favor of doing a regular DROP. Also, cause CREATE TABLE to account completely correctly for the inheritance status of the OID column. This fixes problems with dropping OID columns that have dependencies, as noted by Christopher Kings-Lynne, as well as making sure that you can't drop an OID column that was inherited from a parent. --- doc/src/sgml/ref/alter_table.sgml | 13 ++++++------- 1 file changed, 6 insertions(+), 7 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index 3411c1f24a7..0c536c6d3b8 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -1,5 +1,5 @@ @@ -150,12 +150,11 @@ ALTER TABLE name SET WITHOUT OIDS - This form removes the oid column from the - table. Removing OIDs from a table does not occur immediately. - The space that the OID uses will be reclaimed when the row is - updated. Without updating the row, both the space and the value - of the OID are kept indefinitely. This is semantically similar - to the DROP COLUMN process. + This form removes the oid system column from the + table. This is exactly equivalent to + DROP COLUMN oid RESTRICT, + except that it will not complain if there is already no + oid column. -- cgit v1.2.3