From: | "Sondaar, Roelof" <roelof(dot)sondaar(at)scania(dot)com> |
---|---|
To: | "'Peter Eisentraut'" <peter_e(at)gmx(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | RE: timestamp error cant find class for type 1296 |
Date: | 2000-03-31 15:05:17 |
Message-ID: | 085AAC4CBB98D111936B00A0C9449A6D7C1540@sv7001.nl.scania.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello Peter,
Can you explain this more in detail, because I fail to see the difference in
the following:
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
[PostgreSQL 6.5.3 on hppa1.1-hp-hpux10.20, compiled by cc -Ae ]
snlsor=> create table test2 ( id integer primary key);
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'test2_pkey'
for table 'test2'
CREATE
snlsor=> create table test3 (id datetime primary key);
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'test3_pkey'
for table 'test3'
CREATE
Best regards,
Roelof
> -----Original Message-----
> From: Peter Eisentraut [SMTP:e99re41(at)DoCS(dot)UU(dot)SE]
> Sent: vrijdag 31 maart 2000 15:09
> To: crypt0genic
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] timestamp error cant find class for type 1296
>
> 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 | anonymous | 2000-03-31 15:20:29 | How do I change the default editor in psql |
Previous Message | Guillaume Rousse | 2000-03-31 14:52:14 | Error compiling beta 3 |