RE: pg_dump not working

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

> -----Original Message-----
> From: Philip Warner [mailto:pjw(at)rhyme(dot)com(dot)au]
> Sent: Monday, 31 July 2000 17:38
> To: chris(at)aims(dot)com(dot)au; pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] 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 |/
>