int8 & primary key error

Поиск
Список
Период
Сортировка
От Mike Erickson
Тема int8 & primary key error
Дата
Msg-id lZsS2.4385$1q5.4845@news.rdc1.bc.wave.home.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [BUGS] General Bug Report: Documentation problem
Следующее
От: Unprivileged user
Дата:
Сообщение: General Bug Report: configure finds 8 byte int types, but int8 fails to work at runtime