From: | crypt0genic <crypt0genic(at)ecad(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | timestamp error cant find class for type 1296 |
Date: | 2000-03-31 11:13:34 |
Message-ID: | 20000331111334.C4242@ecad.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 out what 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
From | Date | Subject | |
---|---|---|---|
Next Message | Sondaar, Roelof | 2000-03-31 12:43:01 | RE: timestamp error cant find class for type 1296 |
Previous Message | Ram | 2000-03-31 06:17:45 | clutering/mirroring in Postgresql |