Re: "PQgetvalue: ERROR! - Mailing list pgsql-hackers

From Tom Lane
Subject Re: "PQgetvalue: ERROR!
Date
Msg-id 27339.989002213@sss.pgh.pa.us
Whole thread Raw
In response to "PQgetvalue: ERROR!  ("Antonio Jose Acuña Jimenez" <aj_acuna@hotmail.com>)
List pgsql-hackers
"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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [Fwd: Re: [GENERAL] Unisersal B-Tree]
Next
From: Roberto Mello
Date:
Subject: Postmaster refuses to start