Re: bug in 7.4 SET WITHOUT OIDs

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: bug in 7.4 SET WITHOUT OIDs
Дата
Msg-id 200406090132.i591Wpr04808@candle.pha.pa.us
обсуждение исходный текст
Ответ на bug in 7.4 SET WITHOUT OIDs  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Ответы Re: bug in 7.4 SET WITHOUT OIDs  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список pgsql-hackers
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
> 
> 
> Chris
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Mark Kirkwood
Дата:
Сообщение: Re: Frequently updated tables
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: bug in 7.4 SET WITHOUT OIDs