Search Postgresql Archives

8.2.4 error restoring dump because of gin__int_ops

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



When restoring a dump, I get the following error:

ERROR: could not make operator class "gin__int_ops" be default for type pg_catalog.int4[]
DETAIL:  Operator class "_int4_ops" already is the default.

I believe the problem lies with:

CREATE OPERATOR CLASS gin__int_ops
   DEFAULT FOR TYPE integer[] USING gin AS
   STORAGE integer ,
   OPERATOR 3 &&(integer[],integer[]) ,
   OPERATOR 6 =(anyarray,anyarray) RECHECK ,
   OPERATOR 7 @>(integer[],integer[]) ,
   OPERATOR 8 <@(integer[],integer[]) RECHECK ,
   OPERATOR 13 @(integer[],integer[]) ,
   OPERATOR 14 ~(integer[],integer[]) RECHECK ,
   OPERATOR 20 @@(integer[],query_int) ,
   FUNCTION 1 btint4cmp(integer,integer) ,
   FUNCTION 2 ginarrayextract(anyarray,internal) ,
   FUNCTION 3 ginint4_queryextract(internal,internal,smallint) ,
   FUNCTION 4 ginint4_consistent(internal,smallint,internal);

I saw a bug report on a bug with a similar error message I found a bug report using linux/8.2.0. Has this been resolved? Is there aworkaround?

Carlo

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
      message can get through to the mailing list cleanly

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux