From: | David Sauer <davids(at)iol(dot)cz> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | bug(?) if int8 as primary key |
Date: | 1998-12-23 13:26:06 |
Message-ID: | m2ogovrnv5.fsf@iol.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)iol(dot)cz (mime compatible)
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Bartunov | 1998-12-23 14:10:16 | Re: [HACKERS] bug(?) if int8 as primary key |
Previous Message | David Sauer | 1998-12-23 11:49:13 | Re: [HACKERS] (stupid) bug in agg_select_candidate |