| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Scott Ribe <scott_ribe(at)killerbytes(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Why would query return PGRES_NONFATAL_ERROR? |
| Date: | 2004-04-09 17:38:22 |
| Message-ID: | 27119.1081532302@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Scott Ribe <scott_ribe(at)killerbytes(dot)com> writes:
> I'm using 7.3.2, invoke a small stored procedure via PQexec, and
> PQresultStatus returns PGRES_NONFATAL_ERROR. I can find nothing in the docs
> to help me understand what could cause this, and PQresultErrorMessage is
> blank.
Hmm ... PGRES_NONFATAL_ERROR is only used for reporting NOTICE messages
coming from the backend, and AFAICS such a result should never be
returned out of PQexec; it's only passed to the notice-message receiver.
You say you're getting it back from PQexec? You *sure* your libpq is
7.3 vintage?
> I've gone into postgresql.conf and upped the logging info. Any clues as to
> what I should be looking for?
A NOTICE or WARNING sent to that client ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-04-09 17:53:14 | Re: Why would query return PGRES_NONFATAL_ERROR? |
| Previous Message | Tom Lane | 2004-04-09 17:23:09 | Re: \? not working in psql |