int8 & primary key error - Mailing list pgsql-bugs

From Mike Erickson
Subject int8 & primary key error
Date
Msg-id lZsS2.4385$1q5.4845@news.rdc1.bc.wave.home.com
Whole thread Raw
List pgsql-bugs
I received the following error:

pos=> CREATE TABLE item (upc INT8 CONSTRAINT pk_upc PRIMARY KEY);
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index pk_upc for
table it
em
ERROR:  Can't find a default operator class for type 20.

anyone know what it means? I need to use an int8 field as the primary key in
a database I'm building but it won't let me... I have succesfully created
other tables so I know Postgres is working..
is there a place to look up error messages?

****************************************************************
Mike Erickson
Self-Proclaimed Expert at Everything
mikeisnot@home.com
www.camosun.bc.ca/~cst97023
****************************************************************



pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [BUGS] General Bug Report: Documentation problem
Next
From: Unprivileged user
Date:
Subject: General Bug Report: configure finds 8 byte int types, but int8 fails to work at runtime