Skip site navigation (1) Skip section navigation (2)

bug(?) if int8 as primary key

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 (view raw or flat)
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)

Responses

pgsql-hackers by date

Next:From: Oleg BartunovDate: 1998-12-23 14:10:16
Subject: Re: [HACKERS] bug(?) if int8 as primary key
Previous:From: David SauerDate: 1998-12-23 11:49:13
Subject: Re: [HACKERS] (stupid) bug in agg_select_candidate

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group