Postgres Pro
Downloads
Home   >   mailing lists

Re: ALTER TABLE .. < ADD | DROP > OIDS - Mailing list pgsql-performance

From Rod Taylor
Subject Re: ALTER TABLE .. < ADD | DROP > OIDS
Date
Msg-id 1039209840.2742.142.camel@jester
Whole thread Raw
In response to Re: ALTER TABLE .. < ADD | DROP > OIDS  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
> > That helps DROP OID.  How about ADD OID?
>
> What about it?  I think it'll work just like adding a column, except
> that OID will probably read as 0 not NULL if the row hasn't been updated
> yet.  (You could probably make it read as NULL if you wanted though.)

Good point. I forgot new columns were empty by default.

--
Rod Taylor <rbt@rbt.ca>

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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: ALTER TABLE .. < ADD | DROP > OIDS
Next
From: Tom Lane
Date:
Subject: Re: ORDER BY ... LIMIT.. performance