Thread: Re: ALTER TABLE .. SET WITHOUT OIDS -- ROUND 2
On Thu, 2003-01-16 at 13:41, Peter Eisentraut wrote: > Rod Taylor writes: > > > Code for WITHOUT OIDS. > > Why not ALTER TABLE x DROP COLUMN oid? Thats a really good question considering we can't add OIDs. -- Rod Taylor <rbt@rbt.ca> PGP Key: http://www.rbt.ca/rbtpub.asc
Attachment
Where are we on this? Do folks prefer DROP COLUMN oid? --------------------------------------------------------------------------- Rod Taylor wrote: -- Start of PGP signed section. > On Thu, 2003-01-16 at 13:41, Peter Eisentraut wrote: > > Rod Taylor writes: > > > > > Code for WITHOUT OIDS. > > > > Why not ALTER TABLE x DROP COLUMN oid? > > Thats a really good question considering we can't add OIDs. > > -- > Rod Taylor <rbt@rbt.ca> > > PGP Key: http://www.rbt.ca/rbtpub.asc -- End of PGP section, PGP failed! -- 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, Pennsylvania 19073
On Mon, 2003-02-03 at 07:29, Bruce Momjian wrote: > Where are we on this? Do folks prefer DROP COLUMN oid? I did a request for vote on -hackers, and it came out to WITHOUT OIDs: http://groups.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&safe=off&frame=right&th=c14f51a48c98556f&seekm=26426.1042744046%40sss.pgh.pa.us#link1 But, Peter has since suggested we may want to make OIDs a user column and simply drop it as a system column -- which I prefer, but don't have time to complete anytime soon. > --------------------------------------------------------------------------- > > Rod Taylor wrote: > -- Start of PGP signed section. > > On Thu, 2003-01-16 at 13:41, Peter Eisentraut wrote: > > > Rod Taylor writes: > > > > > > > Code for WITHOUT OIDS. > > > > > > Why not ALTER TABLE x DROP COLUMN oid? > > > > Thats a really good question considering we can't add OIDs. > > > > -- > > Rod Taylor <rbt@rbt.ca> > > > > PGP Key: http://www.rbt.ca/rbtpub.asc > -- End of PGP section, PGP failed! -- Rod Taylor <rbt@rbt.ca> PGP Key: http://www.rbt.ca/rbtpub.asc
Attachment
OK, thanks. WITHOUT OIDS patch added to the queue. Someday, if we make the oid change, we can change ALTER. It's not like it is a common command. --------------------------------------------------------------------------- Rod Taylor wrote: -- Start of PGP signed section. > On Mon, 2003-02-03 at 07:29, Bruce Momjian wrote: > > Where are we on this? Do folks prefer DROP COLUMN oid? > > I did a request for vote on -hackers, and it came out to WITHOUT OIDs: > http://groups.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&safe=off&frame=right&th=c14f51a48c98556f&seekm=26426.1042744046%40sss.pgh.pa.us#link1 > > > But, Peter has since suggested we may want to make OIDs a user column > and simply drop it as a system column -- which I prefer, but don't have > time to complete anytime soon. > > > --------------------------------------------------------------------------- > > > > Rod Taylor wrote: > > -- Start of PGP signed section. > > > On Thu, 2003-01-16 at 13:41, Peter Eisentraut wrote: > > > > Rod Taylor writes: > > > > > > > > > Code for WITHOUT OIDS. > > > > > > > > Why not ALTER TABLE x DROP COLUMN oid? > > > > > > Thats a really good question considering we can't add OIDs. > > > > > > -- > > > Rod Taylor <rbt@rbt.ca> > > > > > > PGP Key: http://www.rbt.ca/rbtpub.asc > > -- End of PGP section, PGP failed! > -- > Rod Taylor <rbt@rbt.ca> > > PGP Key: http://www.rbt.ca/rbtpub.asc -- End of PGP section, PGP failed! -- 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, Pennsylvania 19073