Re: 8.2.4 error restoring dump because of gin__int_ops - Mailing list pgsql-general

From Tom Lane
Subject Re: 8.2.4 error restoring dump because of gin__int_ops
Date
Msg-id 14563.1189738362@sss.pgh.pa.us
Whole thread Raw
In response to 8.2.4 error restoring dump because of gin__int_ops  ("Carlo Stonebanks" <stonec.register@sympatico.ca>)
List pgsql-general
"Carlo Stonebanks" <stonec.register@sympatico.ca> writes:
> 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.

This is a dup of bug #3048.  I see that that still has not been fixed in
CVS HEAD, but I'll make sure it happens before we wrap the upcoming set
of releases.

That won't help a whole lot for dealing with an existing broken dump,
though.  I'd suggest removing the "DEFAULT" keyword from the dump
script's definition of gin__int_ops.

            regards, tom lane

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: What's the difference between SET STORAGE MAIN and EXTENDED?
Next
From: Bruce Momjian
Date:
Subject: Re: FATAL: could not reattach to shared memory (Win32)