| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | andy(at)e-molecule(dot)com |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_dump problem... |
| Date: | 2001-06-11 23:00:54 |
| Message-ID: | 14393.992300454@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Andrew W. Schmeder" <andy(at)e-molecule(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Olbersen | 2001-06-11 23:23:29 | Re: [SQL] ORDER BY what? |
| Previous Message | Alex Pilosov | 2001-06-11 22:59:18 | Re: pg_dump problem... |