Error creating index
От | Vince Vielhaber |
---|---|
Тема | Error creating index |
Дата | |
Msg-id | XFMail.990102171842.vev@michvhf.com обсуждение исходный текст |
Ответы |
Re: [HACKERS] Error creating index
Re: [HACKERS] Error creating index |
Список | 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@michvhf.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 entitledto lecture me about bloat than the federal government" -- Tony Snow ==========================================================================
В списке pgsql-hackers по дате отправления: