Error creating index

From: Vince Vielhaber <vev(at)michvhf(dot)com>
To: hackers(at)postgreSQL(dot)org
Subject: Error creating index
Date: 1999-01-02 22:18:42
Message-ID: XFMail.990102171842.vev@michvhf.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


I'm trying to add a unique index to a table. Notice the error message below:

Table = ordertrack
+----------------------------------+----------------------------------+------+
| Field | Type |Length|
+----------------------------------+----------------------------------+------+
| ordernumber | int8 | 8|
| total | money | 4|
| cookie | text | var|
| orderseq | int4 not null default nextval('o | 4|
+----------------------------------+----------------------------------+------+
Index: ordertrack_orderseq_key
cloud9=> create unique index ord1 on ordertrack(ordernumber);
ERROR: Can't find a default operator class for type 20.
cloud9=>

Is this telling me that I can't have an index of type int8? Why not?

FreeBSD 2.2.8, PostgreSQL cvsup'd less than a week ago.

Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev(at)michvhf(dot)com flame-mail: /dev/null
# include <std/disclaimers.h> TEAM-OS2
Online Searchable Campground Listings http://www.camping-usa.com
"There is no outfit less entitled to lecture me about bloat
than the federal government" -- Tony Snow
==========================================================================

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hal Snyder 1999-01-02 22:34:31 snapshot and FreeBSD-2.2.7 not building
Previous Message Goran Thyni 1999-01-02 18:22:05 Re: [HACKERS] Re: XML (was: 2 patches)