pg_dump question - index error?

From: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
To: "pg-general (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: pg_dump question - index error?
Date: 2003-05-01 15:44:50
Message-ID: 73309C2FDD95D11192E60008C7B1D5BB05FED234@snt452.corp.bcbsm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Michael Meskes 2003-05-01 17:27:32 binaries for RH advanced server
Previous Message Tom Lane 2003-05-01 15:34:01 Re: Slow Queries with OR's?