Re: [HACKERS] bug(?) if int8 as primary key

On 23 Dec 1998, David Sauer wrote:

> Date: 23 Dec 1998 14:26:06 +0100
> From: David Sauer <davids(at)iol(dot)cz>
> To: pgsql-hackers(at)postgreSQL(dot)org
> Subject: [HACKERS] bug(?) if int8 as primary key
>
>
> 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

Just tried on my linux box with pgsql 6.4 and this works ok

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

Yes, this problem exists also for me in 6.4

Oleg

> Happy Xmas,
> David
>
> --
> * David Sauer, student of Czech Technical University
> * electronic mail: davids(at)iol(dot)cz (mime compatible)
>

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83