Wierd error when creating a table...

From: Alex Turner <aturner(at)maaco(dot)com>
To: "pgsql-interfaces(at)postgreSQL(dot)org" <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Wierd error when creating a table...
Date: 1999-05-27 17:49:06
Message-ID: 374D8592.12DFE589@maaco.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

When I try to create a table where the primary key is set to be a column
that is of type int8 or int28 it complains giving me the following
error:

ERROR: Can't find a default operator class for type 22.

If I try to define the table again, it tells me that the relation
already exists, yet it doesnt who up on the table list when I hit \d in
psql.

I also get the error if I try to define an index based on a field with
one of those types.

Is this a known bug, or am I trying to do something odd?

TIA

Alex T

Browse pgsql-interfaces by date

  From Date Subject
Next Message JT Kirkpatrick 1999-05-27 18:29:36 illegal page faults. . .
Previous Message Peter T Mount 1999-05-27 17:24:50 Re: [INTERFACES] Re: [GENERAL] JDBC and insert - stack overflow