Re: change in behaviour? Is this a regression in function?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Gavin Atkinson <gavin(dot)atkinson(at)ury(dot)york(dot)ac(dot)uk>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: change in behaviour? Is this a regression in function?
Date: 2003-02-03 14:30:04
Message-ID: 200302031430.h13EU4P11313@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


This will be fixed in 7.3.2.

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

Gavin Atkinson wrote:
> On Sat, 18 Jan 2003, Tom Lane wrote:
>
> > Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > > Tom Lane wrote:
> > >> So I guess the question at this point is do we want to flip-flop the
> > >> behavior yet again, or leave well enough alone?
> >
> > > I don't have a problem with making no oids the default. I just think
> > > CREATE TABLE and CREATE TABLE AS should behave similarly in terms of
> > > oids.
> >
> > Well, that is a good point. If we are going to change it back, I'd vote
> > for back-patching the change into 7.3.2 so as to minimize the exposure
> > of the current behavior.
> >
> > Any other opinions out there?
>
> I'm in favour of this, as it came as quite a suprise when my application
> stopped working and I spent quite a bit of time debugging it (I
> originally thought it was a configuration option difference). I like the
> idea of having WITH and WITHOUT OIDS options to CREATE TABLE AS as well -
> there have been quite a few times when I have not needed them. But, like
> CREATE TABLE, i think oids should be created by default.
>
> Gavin
>

--
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-general by date

  From Date Subject
Next Message Simon Mitchell 2003-02-03 14:31:42 Re: Creation of VIEWS not working....
Previous Message Tom Lane 2003-02-03 14:21:07 Re: commit errors