Re: timestamp error cant find class for type 1296 - Mailing list 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
pointout what Im doin wrong. 
>
> Thnx all,
> -crypt0genic
>
>
>
>

--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden