"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