Re: pgsql 'prefix' error - Mailing list pgsql-general

From Bino Oetomo
Subject Re: pgsql 'prefix' error
Date
Msg-id 4B0CC78B.4010902@indoakses-online.com
Whole thread Raw
In response to Re: pgsql 'prefix' error  (Harald Fuchs <hari.fuchs@gmail.com>)
List pgsql-general
Dear Harald
Harald Fuchs wrote:
> At least in prefix 1.0.0 unique indexes seem to be broken.  Just drop
> the primary key and add a separate index:
>
> CREATE INDEX myrecords_record_ix ON myrecords USING gist (record);
>
>
>

Yup .. it works now.

Thankyou for your enlightment

Sincerely
-bino-

pgsql-general by date:

Previous
From: John Oyler
Date:
Subject: Re: Re: I need help creating a composite type with some sort of constraints.
Next
From: RD黄永卫
Date:
Subject: How duplicate data produce when a UNIQUE index exite ?