Re: OID

Thanks, so it seems that i can delete the OIDs but not insert them okay
so i have to recreate the table.

Terry Lee Tucker schrieb:

> On Friday 09 June 2006 06:34 am, "Bert" <clemens(dot)bertschler(at)gmail(dot)com> thus
> communicated:
> --> Hi list
> --> What is the comment to add OIDs to a already existing table, or i have
> --> to recreate the table?
> -->
> --> Thanks,
> --> Clemens
> -->
> -->
> Well, according on \h ALTER TABLE on version 7.4.6 all you can do is SET
> WITHOUT OIDS.
>
> master=# \h alter table
> Command: ALTER TABLE
> Description: change the definition of a table
> Syntax:
> ALTER TABLE [ ONLY ] name [ * ]
> ADD [ COLUMN ] column type [ column_constraint [ ... ] ]
> ALTER TABLE [ ONLY ] name [ * ]
> DROP [ COLUMN ] column [ RESTRICT | CASCADE ]
> ALTER TABLE [ ONLY ] name [ * ]
> ALTER [ COLUMN ] column { SET DEFAULT expression | DROP DEFAULT }
> ALTER TABLE [ ONLY ] name [ * ]
> ALTER [ COLUMN ] column { SET | DROP } NOT NULL
> ALTER TABLE [ ONLY ] name [ * ]
> ALTER [ COLUMN ] column SET STATISTICS integer
> ALTER TABLE [ ONLY ] name [ * ]
> ALTER [ COLUMN ] column SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN }
> ALTER TABLE [ ONLY ] name [ * ]
> SET WITHOUT OIDS
> ALTER TABLE [ ONLY ] name [ * ]
> RENAME [ COLUMN ] column TO new_column
> ALTER TABLE name
> RENAME TO new_name
> ALTER TABLE [ ONLY ] name [ * ]
> ADD table_constraint
> ALTER TABLE [ ONLY ] name [ * ]
> DROP CONSTRAINT constraint_name [ RESTRICT | CASCADE ]
> ALTER TABLE name
> OWNER TO new_owner
> ALTER TABLE name
> CLUSTER ON index_name
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend