Postgres Pro
Downloads
Home   >   mailing lists

Thread: I can not create Index on a feild by type 'timestmp'!

I can not create Index on a feild by type 'timestmp'!

From
Hasan Mokhtari Sangchi
Date:
Hellor dear.
If I want to create an index on a field by type 'timestamp'
postgres give me following error message :
    ' can not find a default operator class for type 1296.'
what can I do ?

Thank a lot.

RE: I can not create Index on a feild by type 'timestmp'!

From
Mike Mascari
Date:
That sounds like an old error to me if I recall correctly. What
version of PostgreSQL are you using?

SELECT version();

Mike Mascari
mascarm@mascari.com

-----Original Message-----
From:    Hasan Mokhtari Sangchi [SMTP:mokhtari@hadid.sharif.ac.ir]
Sent:    Wednesday, April 25, 2001 5:55 AM
To:    pgsql-general@postgresql.org
Subject:    [GENERAL] I can not create Index on a feild by type
'timestmp'!

Hellor dear.
If I want to create an index on a field by type 'timestamp'
postgres give me following error message :
    ' can not find a default operator class for type 1296.'
what can I do ?

Thank a lot.

Re: I can not create Index on a feild by type 'timestmp'!

From
Tom Lane
Date:
Hasan Mokhtari Sangchi <mokhtari@hadid.sharif.ac.ir> writes:
> If I want to create an index on a field by type 'timestamp'
> postgres give me following error message :
>     ' can not find a default operator class for type 1296.'
> what can I do ?

Upgrade to a more recent version of Postgres.

Or, change the field to be type datetime, which is the better-supported
datatype in old versions...

            regards, tom lane