timestamp error cant find class for type 1296

Поиск
Список
Период
Сортировка
От crypt0genic
Тема timestamp error cant find class for type 1296
Дата
Msg-id 20000331111334.C4242@ecad.org
обсуждение исходный текст
Ответы Re: timestamp error cant find class for type 1296  (Peter Eisentraut <e99re41@DoCS.UU.SE>)
Список pgsql-general
When attempting to create the following table:

CREATE TABLE test (
                                id timestamp primary key,
                                fodder varchar(64)
                                );


I get the following error:
ERROR:  Can't fine a default operator CLASS for type 1296

Whats that all about? ;)

If I create the table as follows (which AFAIK is equivilant):
CREATE TABLE test2 (
                                id datetime primary key,
                                fodder varchar(64)
                                );

It creates fine but when I try to insert something like:

INSERT INTO test2 (fodder) VALUES ('arfarf');

I get:
ERROR: ExecAppend: Fail to add null value in not null value attribute id

I thought that the datetime field would be filled automatically on a insert with a current timestamp. can someone point
outwhat Im doin wrong. 

Thnx all,
-crypt0genic



--
Reverse engineering, the most fun and usually the most effective way
to tackle a problem or learn something new.
Public PGP key:        http://www.ecad.org/crypt0genic.pkr
Fingerprint:         A4F6 9F69 7C89 0AC0 9F9F  583B 64E0 AB8E 36DA A2A2

В списке pgsql-general по дате отправления:

Предыдущее
От: Ram
Дата:
Сообщение: clutering/mirroring in Postgresql
Следующее
От: "Bruno Totaro Durazzi"
Дата:
Сообщение: Run PostgreSQL 6.5 on Tru64 Platform?