Re: ALTER TABLE .. SET WITHOUT OIDS -- ROUND 2

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Rod Taylor <rbt(at)rbt(dot)ca>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: ALTER TABLE .. SET WITHOUT OIDS -- ROUND 2
Date: 2003-02-03 13:06:19
Message-ID: 200302031306.h13D6JD12942@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches


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(at)rbt(dot)ca>
> > >
> > > PGP Key: http://www.rbt.ca/rbtpub.asc
> > -- End of PGP section, PGP failed!
> --
> Rod Taylor <rbt(at)rbt(dot)ca>
>
> PGP Key: http://www.rbt.ca/rbtpub.asc
-- End of PGP section, PGP failed!

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

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2003-02-03 14:24:44 Re: Docs for service file
Previous Message Bruce Momjian 2003-02-03 13:05:23 Re: ALTER TABLE .. SET WITHOUT OIDS -- ROUND 2