Neil Conway <neilc@samurai.com> writes:
> On Mon, 2003-09-29 at 18:37, Tom Lane wrote:
>> It doesn't seem to me that this really buys much. What we really want
>> is a way for a dump/reload to remove OIDs from tables that formerly had
>> them; otherwise people will not easily be able to migrate their existing
>> tables away from having OIDs.
> Can't they just use ALTER TABLE ... WITHOUT OIDS?
That's true --- I'd forgotten we had that.
>>> ... and a single SET can apply to
>>> multiple CREATE TABLEs.
>>
>> Not unless you want partial pg_restores to break.
> So is it worth doing this rather than WITH/WITHOUT OIDS, then?
[shrug] It seems quite cosmetic to me. What might be more useful is
an option to keep pg_dump from saying either WITH OIDS or WITHOUT OIDS,
probably as part of a more general "suppress Postgres-isms" option.
regards, tom lane