Skip site navigation (1) Skip section navigation (2)

Re: ALTER TABLE .. < ADD | DROP > OIDS

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Pgsql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: ALTER TABLE .. < ADD | DROP > OIDS
Date: 2002-12-06 20:35:32
Message-ID: 1039206932.2742.85.camel@jester (view raw or flat)
Thread:
Lists: pgsql-performance
On Fri, 2002-12-06 at 15:19, Tom Lane wrote:
> Rod Taylor <rbt(at)rbt(dot)ca> writes:
> > I wish to create an alter command which will allow a table to have OIDs
> > added or removed.
> 
> > The tricky part appears to be changing the tuples themselves.

> There might be a few places that look at the pg_class.relhasoids
> field where they should be examining the tuple header has-oid bit,
> but I don't think there are many.

Ok.. If you think thats safe, I'll give it a try.  I was afraid that the
system would confuse itself if the table had mix and matched tuples in
it.  New tuples without oids, old tuples with.

That helps DROP OID.  How about ADD OID?

-- 
Rod Taylor <rbt(at)rbt(dot)ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

In response to

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2002-12-06 20:46:05
Subject: Re: Speeding up aggregates
Previous:From: Tom LaneDate: 2002-12-06 20:19:04
Subject: Re: ALTER TABLE .. < ADD | DROP > OIDS

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group