Обсуждение: How do I get more error codes from libpq

Поиск
Список
Период
Сортировка

How do I get more error codes from libpq

От
Fangbing Wu
Дата:
<br /> I'm just getting started to use libpq to access my DB with<br /> PQexecParam etc. <br /> I'm still searching for
waysto get detailed error codes from libpq,<br /> say when a request was denied due to permission etc.<br /> Is stuff
likethis possible?<br /><br /> Thanks!<br /> FBW<br />

Re: How do I get more error codes from libpq

От
Michael Fuhr
Дата:
On Tue, Oct 11, 2005 at 10:59:19PM -0400, Fangbing Wu wrote:
> I'm just getting started to use libpq to access my DB with
> PQexecParam etc.
> I'm still searching for ways to get detailed error codes from libpq,
> say when a request was denied due to permission etc.
> Is stuff like this possible?

Yes, just read a little farther down the "Command Execution Functions"
documentation:

http://www.postgresql.org/docs/8.0/interactive/libpq-exec.html

-- 
Michael Fuhr

Re: How do I get more error codes from libpq

От
Fangbing Wu
Дата:
Yeah,

I'm still in the process of reading more of the doc. But my question is more like
when I get something like PGRES_BAD_RESPONSE or PGRES_NONFATAL_ERROR, how would
I go about to find out what's the cause of such an error?
Could it be due to access right problems or some other transient conditions?
Is there a way to get those info.?

Thanks!
Fangbing


On 10/11/05, Michael Fuhr <mike@fuhr.org> wrote:
On Tue, Oct 11, 2005 at 10:59:19PM -0400, Fangbing Wu wrote:
> I'm just getting started to use libpq to access my DB with
> PQexecParam etc.
> I'm still searching for ways to get detailed error codes from libpq,
> say when a request was denied due to permission etc.
> Is stuff like this possible?

Yes, just read a little farther down the "Command Execution Functions"
documentation:

http://www.postgresql.org/docs/8.0/interactive/libpq-exec.html

--
Michael Fuhr

Re: How do I get more error codes from libpq

От
Fangbing Wu
Дата:
With more reading, I think I got what I was after. The routine
char *PQresultErrorField(const PGresult *res, int fieldcode);

gives me what I want.

Thanks!
Fangbing

On 10/12/05, Fangbing Wu <fangbingw@gmail.com> wrote:
Yeah,

I'm still in the process of reading more of the doc. But my question is more like
when I get something like PGRES_BAD_RESPONSE or PGRES_NONFATAL_ERROR, how would
I go about to find out what's the cause of such an error?
Could it be due to access right problems or some other transient conditions?
Is there a way to get those info.?

Thanks!
Fangbing



On 10/11/05, Michael Fuhr <mike@fuhr.org> wrote:
On Tue, Oct 11, 2005 at 10:59:19PM -0400, Fangbing Wu wrote:
> I'm just getting started to use libpq to access my DB with
> PQexecParam etc.
> I'm still searching for ways to get detailed error codes from libpq,
> say when a request was denied due to permission etc.
> Is stuff like this possible?

Yes, just read a little farther down the "Command Execution Functions"
documentation:

http://www.postgresql.org/docs/8.0/interactive/libpq-exec.html

--
Michael Fuhr