Re: WIP: fix SET WITHOUT OIDS, add SET WITH OIDS - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: WIP: fix SET WITHOUT OIDS, add SET WITH OIDS
Date
Msg-id 49905D25.5050108@enterprisedb.com
Whole thread Raw
In response to Re: WIP: fix SET WITHOUT OIDS, add SET WITH OIDS  (Marko Kreen <markokr@gmail.com>)
Responses Re: WIP: fix SET WITHOUT OIDS, add SET WITH OIDS  (Marko Kreen <markokr@gmail.com>)
List pgsql-hackers
Marko Kreen wrote:
> We've set default_with_oids = false, for quite a long time.  But there
> are still tables remaining with oids.  And this discussion showed it
> now easy to get rid of them.

Do you still need the oids? If not, run ALTER TABLE WITHOUT OIDS before 
upgrading to 8.4, while it's still fast. If yes, you couldn't use the 
option to remove them at pg_dump anyway because you still need them 
after the upgrade.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Marko Kreen
Date:
Subject: Re: WIP: fix SET WITHOUT OIDS, add SET WITH OIDS
Next
From: Tom Lane
Date:
Subject: Re: WIP: fix SET WITHOUT OIDS, add SET WITH OIDS