Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
>> I am currently testing a fix that allows you to say
>> ALTER TABLE DROP COLUMN oid;
>> which will behave the same way a regular user-column DROP would.
> Will it handle this case:
> usa=# create table testy (a int4) without oids;
> usa=# alter table testy add oid int4;
No. This is DROP not ADD.
> How about the syntax:
> ALTER TABLE t DROP OIDS;
Why? We already have one nonstandard-and-redundant syntax for this,
we surely do not need another.
regards, tom lane