From: | Peter Eisentraut <e99re41(at)DoCS(dot)UU(dot)SE> |
---|---|
To: | crypt0genic <crypt0genic(at)ecad(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: timestamp error cant find class for type 1296 |
Date: | 2000-03-31 13:09:01 |
Message-ID: | Pine.GSO.4.02A.10003311508410.10283-100000@Stork.DoCS.UU.SE |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
You can't create an index on timestamp in <7.0 versions.
On Fri, 31 Mar 2000, crypt0genic wrote:
>
> 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
>
>
>
>
--
Peter Eisentraut Sernanders väg 10:115
peter_e(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2000-03-31 13:12:42 | Re: doing backups |
Previous Message | Sondaar, Roelof | 2000-03-31 12:43:01 | RE: timestamp error cant find class for type 1296 |