change in behaviour? Is this a regression in function?

From: Gavin Atkinson <gavin(dot)atkinson(at)ury(dot)york(dot)ac(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: change in behaviour? Is this a regression in function?
Date: 2003-01-17 22:02:51
Message-ID: 20030117214229.I82662-100000@ury.york.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi all,

Sorry if this is the wrong mailing list, I couldn't see a "help" type
list.

Under Postgresql 7.1.3, I could use "create table foo as select * from
bar" and the table would be created with OIDs.

Under Postgres 7.3.1, this no longer seems to be the case:

> test=> select oid from bar;
> oid
> --------
> 17168
> 17175
> (2 rows)
>
> test=> create table foo as select * from bar;
> SELECT
> test=> select oid from foo;
> ERROR: Attribute "oid" not found

Compare this with version 7.1.3, on a different box:

> test=> select oid from bar;
> oid
> --------
> 102406
> 102526
> (2 rows)
>
> test=> create table foo as select * from bar;
> SELECT
> test=> select oid from foo;
> oid
> --------
> 104307
> 104308
> (2 rows)

Is this a configuration problem at my end (I can't see anything wrong, but
the two versions are on different machines) or is it a problem with
version 7.3.1. Or was I simply relying on an undocumented feature? If the
latter, what is the best way of getting round this? Both versions are
running on FreeBSD, and were compiled from source, if it helps. They are
using the standard config files, but have the pg_hba access permissions
locked down to one specific IP address.

Thanks,

Gavin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Cheryl Thompson 2003-01-17 22:15:21 Driver Frustration// Perl DBI
Previous Message Greg Stark 2003-01-17 21:33:22 Re: point -> double,double ?