Thread: "PQgetvalue: ERROR!

"PQgetvalue: ERROR!

From
"Antonio Jose Acuña Jimenez"
Date:
Hello to all
I need help in the following one for the following error

"PQGETVALUE: ERROR! tuple number 0 is out of range 0.. -1 Segment violation"

This happens when I make a pg_dump namebd > namebd.dump

I work posgresql 7.0.3 with mandrake 7.2

A thousand thank you

Antonio Acu�a





Re: "PQgetvalue: ERROR!

From
Tom Lane
Date:
"Antonio Jose Acu�a Jimenez" <aj_acuna@hotmail.com> writes:
> I need help in the following one for the following error

> "PQGETVALUE: ERROR! tuple number 0 is out of range 0.. -1
>   Segment violation"

Pre-7.1 versions of pg_dump are not very robust about situations like
functions whose owner doesn't exist anymore, tables that refer to
nonexistent datatypes, that sort of thing.  The above is not enough
to narrow down the problem, however.  Try starting the postmaster with
-d2 so that you can get a log of pg_dump's queries; then look to see
what's the last query processed before it crashes.  That should let you
figure out which database item has the dangling reference.
        regards, tom lane