"Carlo Stonebanks" <stonec.register@xxxxxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
