Neil Conway <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to