Re: Wacky OID idea

Added to TODO:

o Add ALTER TABLE tab SET WITHOUT OIDS

---------------------------------------------------------------------------

Christopher Kings-Lynne wrote:
> > I don't think it would be easy to do this without rewriting the table,
> > as Alvaro suggested. And if you're going to give this DROP COLUMN
> > variant totally different behavior from any other form of DROP COLUMN,
> > ISTM that it doesn't belong with DROP COLUMN.
>
> Especially if we start saving the 4 bytes that a NULL oid takes up in a
> table tuple on disk.
>
> Perhaps:
>
> ALTER TABLE tab SET WITHOUT OIDS;
>
> I think the reverse operation would really be impossible...? Unless we run
> through the entire table and insert an oid for each row from the oid
> counter?
>
> > That said, being able to remove the OIDs from a table would be fairly
> > useful, IMHO.
>
> Hell yeah.
>
> By the way - I'm not saying I'll be implementing this any time soon!
>
> Chris
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073