From 8195f8f0427e0387f595ca951e4dcc257655e891 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Thu, 13 Feb 2003 05:20:05 +0000 Subject: Code for WITHOUT OIDS. On Wed, 2003-01-08 at 21:59, Christopher Kings-Lynne wrote: > I agree. I want to remove OIDs from heaps of our tables when we go to 7.3. > I'd rather not have to do it in the dump due to down time. Rod Taylor --- doc/src/sgml/ref/alter_table.sgml | 19 +++++++++++++++++-- 1 file changed, 17 insertions(+), 2 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index 2287a72cb65..5499cd158cc 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -1,5 +1,5 @@ @@ -33,6 +33,8 @@ ALTER TABLE [ ONLY ] table [ * ] ALTER [ COLUMN ] column SET STATISTICS integer ALTER TABLE [ ONLY ] table [ * ] ALTER [ COLUMN ] column SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN } +ALTER TABLE [ ONLY ] table [ * ] + SET WITHOUT OIDS ALTER TABLE [ ONLY ] table [ * ] RENAME [ COLUMN ] column TO new_column @@ -286,11 +288,24 @@ ALTER TABLE table + + SET WITHOUT OIDS + + + Removes the OID column from the the table. Removing (setting without) + oids from a table also do not occur immediately. The space an OID + uses will be reclaimed when the tuple is updated. Without updating the tuple, both the + space and the value of the OID are maintained indefinitely. This is + semantically similar to the DROP COLUMN process. + + + + RENAME - The RENAME forms change the name of a table + The RENAME forms change the name of a table (or an index, sequence, or view) or the name of an individual column in a table. There is no effect on the stored data. -- cgit v1.2.3