Re: deprecating the use of OIDs - Mailing list pgsql-hackers

From Neil Conway
Subject Re: deprecating the use of OIDs
Date
Msg-id 1064875302.22627.2.camel@tokyo
Whole thread Raw
In response to Re: deprecating the use of OIDs  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: deprecating the use of OIDs
List pgsql-hackers
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?

> > ... 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?

-Neil




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: deprecating the use of OIDs
Next
From: Stephan Szabo
Date:
Subject: Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta)