Re: bug in 7.4 SET WITHOUT OIDs - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: bug in 7.4 SET WITHOUT OIDs
Date
Msg-id 40C66FBD.6050501@familyhealth.com.au
Whole thread Raw
In response to Re: bug in 7.4 SET WITHOUT OIDs  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: bug in 7.4 SET WITHOUT OIDs
List pgsql-hackers
Yep, Tom fixed it good.

Bruce Momjian wrote:

> I can confirm that current CVS handles this OK.
> 
> ---------------------------------------------------------------------------
> 
> Christopher Kings-Lynne wrote:
> 
>>I had a suspicion and it was confirmed:
>>
>>test=# create table oidtest (a int4, unique(oid));
>>NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
>>"oidtest_oid_key" for table "oidtest"
>>CREATE TABLE
>>test=# select oid from oidtest;
>>  oid
>>-----
>>(0 rows)
>>
>>test=# alter table oidtest set without oids;
>>ALTER TABLE
>>test=# select oid from oidtest;
>>ERROR:  column "oid" does not exist
>>test=# \d oidtest
>>ERROR:  cache lookup failed for attribute -2 of relation 765798



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: bug in 7.4 SET WITHOUT OIDs
Next
From: Tom Lane
Date:
Subject: Assignment to array elements