From: | "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
---|---|
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:56:15 |
Message-ID: | 3681048F.5BE33D7C@alumni.caltech.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> 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.
int8 is a new data type, and I did not create the functions and catalog
entries required to implement a b-tree index yet. Since int8 relies on
compiler support for 8 byte integers, I wasn't sure how many platforms
would actually be able to compile the type. I think we know now that
most platforms do support the data type, so we should have more complete
support for it in the next release.
> If I restart pgsql, I can create table t (with int as primary key, not
> int8).
Yes, that's funny. It apparently does not quite clean up after itself.
The good news is that you only have to restart your session, not the
postmaster :)
- Tom
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Broytmann | 1998-12-23 15:33:14 | Re: [HACKERS] Date/time on glibc2 linux |
Previous Message | Oleg Bartunov | 1998-12-23 14:10:16 | Re: [HACKERS] bug(?) if int8 as primary key |