diff options
| author | Bruce Momjian <bruce@momjian.us> | 2003-02-13 05:20:05 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2003-02-13 05:20:05 +0000 |
| commit | 8195f8f0427e0387f595ca951e4dcc257655e891 (patch) | |
| tree | 1174ef5cb3c3e240c542260879cfc34a9a9437f9 /doc/src | |
| parent | 8add2e1bcafd92a06fada1098b110638a3d4b7f6 (diff) | |
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 <rbt@rbt.ca>
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/alter_table.sgml | 19 |
1 files changed, 17 insertions, 2 deletions
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 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.54 2003/01/19 00:13:29 momjian Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.55 2003/02/13 05:19:59 momjian Exp $ PostgreSQL documentation --> @@ -34,6 +34,8 @@ ALTER TABLE [ ONLY ] <replaceable class="PARAMETER">table</replaceable> [ * ] ALTER TABLE [ ONLY ] <replaceable class="PARAMETER">table</replaceable> [ * ] ALTER [ COLUMN ] <replaceable class="PARAMETER">column</replaceable> SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN } ALTER TABLE [ ONLY ] <replaceable class="PARAMETER">table</replaceable> [ * ] + SET WITHOUT OIDS +ALTER TABLE [ ONLY ] <replaceable class="PARAMETER">table</replaceable> [ * ] RENAME [ COLUMN ] <replaceable class="PARAMETER">column</replaceable> TO <replaceable class="PARAMETER">new_column</replaceable> ALTER TABLE <replaceable class="PARAMETER">table</replaceable> @@ -287,10 +289,23 @@ ALTER TABLE <replaceable class="PARAMETER">table</replaceable> </varlistentry> <varlistentry> + <term>SET WITHOUT OIDS</term> + <listitem> + <para> + Removes the <literal>OID</literal> column from the the table. Removing (setting without) + oids from a table also do not occur immediately. The space an <literal>OID</literal> + uses will be reclaimed when the tuple is updated. Without updating the tuple, both the + space and the value of the <literal>OID</literal> are maintained indefinitely. This is + semantically similar to the <literal>DROP COLUMN</literal> process. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term>RENAME</term> <listitem> <para> - The <literal>RENAME</literal> forms change the name of a table + The <literal>RENAME</literal> 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. </para> |