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
|
Список | 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 по дате отправления: