bug(?) if int8 as primary key
От | David Sauer |
---|---|
Тема | bug(?) if int8 as primary key |
Дата | |
Msg-id | m2ogovrnv5.fsf@iol.cz обсуждение исходный текст |
Ответы |
Re: [HACKERS] bug(?) if int8 as primary key
|
Список | pgsql-hackers |
My database (pgsql 6.4.1, linux i386, compiled by egcs-1.1.1) does weird things: david=> create table t( i int primary key ); NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index t_pkey for table t CREATE david=> drop table t; DROP *** table t doesn't exist david=> create table t( i int8 primary key ); NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index t_pkey for table t ERROR: Can't find a default operator class for type 20. *** exist table t or not ? david=> create table t( i int primary key ); NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index t_pkey for table t ERROR: t relation already exists *** yes! david=> drop table t; ERROR: Relation t Does Not Exist! *** no! If I restart pgsql, I can create table t (with int as primary key, not int8). Happy Xmas, David -- * David Sauer, student of Czech Technical University * electronic mail: davids@iol.cz (mime compatible)
В списке pgsql-hackers по дате отправления: