From: Fangbing Wu <fangbingw@gmail.com>
To: Michael Fuhr <mike@fuhr.org>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: How do I get more error codes from libpq
Date: Wed, 12 Oct 2005 20:17:10 -0400
Message-ID: <6619c3340510121717h22b0ead5j24749719d7bc9d90@mail.gmail.com> (raw)
In-Reply-To: <6619c3340510121712r3c32f47dicd50ec82d065da4@mail.gmail.com>
References: <6619c3340510111959o770e3b1m3a493480068411d9@mail.gmail.com>
<20051012031428.GA27278@winnie.fuhr.org>
<6619c3340510121712r3c32f47dicd50ec82d065da4@mail.gmail.com>
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
> >
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: fangbingw@gmail.com, mike@fuhr.org
Subject: Re: How do I get more error codes from libpq
In-Reply-To: <6619c3340510121717h22b0ead5j24749719d7bc9d90@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox