Re: OID - Mailing list pgsql-general

From Bert
Subject Re: OID
Date
Msg-id 1149852461.450332.303790@y43g2000cwc.googlegroups.com
Whole thread Raw
In response to Re: OID  (Terry Lee Tucker <terry@esc1.com>)
Responses Re: OID
List pgsql-general
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.bertschler@gmail.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


pgsql-general by date:

Previous
From: Agent M
Date:
Subject: Re: Fabian Pascal and RDBMS deficiencies in fully implementing the relational model
Next
From: Roman Neuhauser
Date:
Subject: Re: Fabian Pascal and RDBMS deficiencies in fully implementing