pg_dump question - index error? - Mailing list pgsql-general

From Johnson, Shaunn
Subject pg_dump question - index error?
Date
Msg-id 73309C2FDD95D11192E60008C7B1D5BB05FED234@snt452.corp.bcbsm.com
Whole thread Raw
List pgsql-general

Running PostgreSQL 7.2.1 on RedHat Linux 7.2.

I'm trying to do a pg_dump of a table and get the schema only and
I get this error after about 10 minutes :

[snip]

pg_dump -s -t test_table  -d testdb > /var/local/schemas/out_table.sch

pg_dump: query to obtain list of indexes failed: ERROR:  syscache lookup for index 3248834497 failed

[/snip]

I've never seen this message before when doing the same thing - how can I correct this?

Thanks!

-X

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Slow Queries with OR's?
Next
From: Michael Meskes
Date:
Subject: binaries for RH advanced server