8.2.4 error restoring dump because of gin__int_ops

Поиск
Список
Период
Сортировка
От Carlo Stonebanks
Тема 8.2.4 error restoring dump because of gin__int_ops
Дата
Msg-id fcc7j3$1v9r$1@news.hub.org
обсуждение исходный текст
Ответы Re: 8.2.4 error restoring dump because of gin__int_ops  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
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


В списке pgsql-general по дате отправления:

Предыдущее
От: "Laimonas Simutis"
Дата:
Сообщение: Re: processing urls with tsearch2
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: AutoVacuum Behaviour Question