Re: pg_restore fails - postgres 7.3.4

Attached.

The previously posted index failure stated:
CREATE INDEX idx_disc_loc ON order_items USING gist (disc, loc);

However in this list it is:
CREATE INDEX idx_item_loc ON content_items USING gist (disclosuer, loc);

Rob

Tom Lane wrote:

> "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?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly