Re: "PQgetvalue: ERROR!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Antonio Jose Acu a Jimenez" <aj_acuna(at)hotmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: "PQgetvalue: ERROR!
Date: 2001-05-04 18:50:13
Message-ID: 27339.989002213@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Antonio Jose Acua Jimenez" <aj_acuna(at)hotmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Joel Burton 2001-05-04 19:15:06 Re: what is the limit for string
Previous Message Peter Eisentraut 2001-05-04 18:49:34 Re: Packaging 7.1.1