Rod Taylor <rbt(at)rbt(dot)ca> writes:
> What is the preferred syntax:
> ALTER TABLE .. DROP COLUMN oid;
> or
> ALTER TABLE .. SET WITHOUT OIDS;
If we ever got around to supporting the inverse function (add oids),
I do not think we'd want to spell it like "ADD COLUMN oid" --- that
would interfere with making a plain user column named "oid", which was
one of the reasons why people wanted to be able to drop OIDs in the
first place.
So I lean towards the SET WITH/WITHOUT OIDS syntax. That keeps it
clearly out of the domain of user columns.
regards, tom lane