From: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
---|---|
To: | David Sauer <davids(at)iol(dot)cz> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] bug(?) if int8 as primary key |
Date: | 1998-12-23 14:10:16 |
Message-ID: | Pine.GSO.3.96.SK.981223170754.10523B-100000@ra |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas G. Lockhart | 1998-12-23 14:56:15 | Re: [HACKERS] bug(?) if int8 as primary key |
Previous Message | David Sauer | 1998-12-23 13:26:06 | bug(?) if int8 as primary key |