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@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