Re: pg_restore fails - postgres 7.3.4

"Rob Long" <rlong(at)micropat(dot)com> writes:
>>> Trying to dump and restore a production database with no success.
>>>
>>> pg_restore: [archiver (db)] could not execute query: ERROR: data type
>>> integer has no default operator class for access method "gist"
>>
>> Hm, this is probably a matter of incorrect object restoration order ...
>> could we see the output of "pg_restore -l" for this dump file?

After playing around with this I realize that it's a bug associated with
schemas --- if you have an operator class that's not in pg_catalog, the
opclass name has to be explicitly qualified in pg_dump's output, or it
won't restore correctly. I'm surprised no one reported this before,
since it affects all the contrib operator classes.

Attached is a patch against 7.3.4, in case it helps.

regards, tom lane