Re: Killing OIDs

On Wed, 2009-02-11 at 09:41 -0800, Steve Crawford wrote:
> I'm about to deal with an upgrade of a server running 7.4. I have
> checked with the developers and they are not using OIDs so I'd like to
> remove them so they aren't carried forward to 8.3.
>
> My plan is to do the OID removal on 7.4. I can get a script with:
> SELECT
> 'ALTER TABLE ' || relname || ' SET WITHOUT OIDS;'
> FROM
> pg_class
> WHERE
> relkind='r' and
> relowner != 1 and
> relhasoids;
>
> Before I pull the trigger, I figured I'd post and find out if anyone
> sees any feet in the way.

That won't drop the OID columns.

Joshua D. Drake

>
> Cheers,
> Steve
>
>
--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997