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@postgresql.org so that your
> message can get through to the mailing list cleanly
>
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073