Re: pg_dump problem...

"Andrew W. Schmeder" <andy@e-molecule.com> writes:
> I am having a problem with the dump/restore operating for a 7.0.2 -> 7.1.2 migration.

> This database won't let me do an export...

> ../bin/pg_dump xapnet_web
> PQgetvalue: ERROR! tuple number 0 is out of range 0..-1

You've probably got an object whose owning user has been deleted,
or some similar loss of a link that pg_dump expects to be there.

I'd suggest trying it with the 7.1.2 pg_dump (which should talk to
7.0.*).  It'll still complain, but with any luck give you a more useful
error message.  (If not, file a bug report.)

Another attack is to run pg_dump with query logging turned on, and
see what the last query issued before the failure is.

            regards, tom lane