pg_dump not working

At 17:00 31/07/00 +1000, Chris Knight wrote:

Howdy,

I've come back from a two week holiday to find that pg_dump isn't working.
I'm running Postgresql 7.0.2 on FreeBSD 2.2.8.
I've stopped the postmaster, backed up the database directory using tar for
safety, and performed a successful vacuum analyze.
The error I'm getting is:

PQgetvalue: ERROR! tuple number 0 is out of range 0..-1
Segmentation fault (core dumped)

To track this down, it might help to see the command you are using and the
output using the '-v' option on pg_dump.

----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.C.N. 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/

Howdy,

Doesn't matter - I did a COPY TO on all the tables, dropped and recreated
the database from my initial SQL scripts, and did a COPY FROM to restore the
data. I'm finding a heap of duplicate key errors on my unique indexes and
referential integrity violation on foreign keyed columns. Anyone know of a
quick way to get the index definitions for all tables, drop and recreate
them?

Thanks in advance for any help.

Regards,
Chris Knight
Systems Administrator
AIMS Independent Computer Professionals
Tel: +61 3 6334 6664 Fax: +61 3 6331 7032 Mob: +61 419 528 795
Web: http://www.aims.com.au