Skip site navigation (1) Skip section navigation (2)

timestamp error cant find class for type 1296

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: (view raw or whole thread)
Lists: pgsql-general
When attempting to create the following table:

								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):
								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,

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


pgsql-general by date

Next:From: Sondaar, RoelofDate: 2000-03-31 12:43:01
Subject: RE: timestamp error cant find class for type 1296
Previous:From: RamDate: 2000-03-31 06:17:45
Subject: clutering/mirroring in Postgresql

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group