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

Gavin Atkinson wrote:
> On Fri, 17 Jan 2003, Tom Lane wrote:
>
> > Gavin Atkinson <gavin(dot)atkinson(at)ury(dot)york(dot)ac(dot)uk> writes:
> > > Under Postgresql 7.1.3, I could use "create table foo as select * from
> > > bar" and the table would be created with OIDs.
> >
> > 7.3 builds it without OIDs. Sorry about that.
>
> Was this an intentional change or will it be fixed in 7.4? Do you know
> which version was first affected by this change? Is there any way around
> it? I'm trying to update postgres but I can't at the moment as the app
> makes extensive use of the oids after a "select table as".

It was an accident and will be fixed in 7.4. I don't think the fix is
in CVS yet. On workaround is to explicitly select the oid column as
part of the SELECT.

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