X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id ADFD2D80BA for ; Wed, 12 Oct 2005 21:12:56 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 20000-03 for ; Thu, 13 Oct 2005 00:12:52 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.193]) by svr1.postgresql.org (Postfix) with ESMTP id 475DAD7117 for ; Wed, 12 Oct 2005 21:12:54 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id j2so251772nzf for ; Wed, 12 Oct 2005 17:12:58 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=ujZehCuOrqwtx7EpECFz/v3nJ/57ZDCcxMn0u9kLP1I9tplRyAO1WE+1ragwSGiOpbQgkcNd5a6zLNIjQHZuSUyJz0yUanBCIC5/94UkDqWN4Qb4HlZApxPFJjeEPxDfqonBgriiu1j+Kr1WzAbIcDKOUu7BVQ2+M/bb1FKsw4Q= Received: by 10.36.37.20 with SMTP id k20mr1450533nzk; Wed, 12 Oct 2005 17:12:57 -0700 (PDT) Received: by 10.36.120.19 with HTTP; Wed, 12 Oct 2005 17:12:57 -0700 (PDT) Message-ID: <6619c3340510121712r3c32f47dicd50ec82d065da4@mail.gmail.com> Date: Wed, 12 Oct 2005 20:12:57 -0400 From: Fangbing Wu To: Michael Fuhr Subject: Re: How do I get more error codes from libpq Cc: pgsql-interfaces@postgresql.org In-Reply-To: <20051012031428.GA27278@winnie.fuhr.org> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_34391_13728232.1129162377853" References: <6619c3340510111959o770e3b1m3a493480068411d9@mail.gmail.com> <20051012031428.GA27278@winnie.fuhr.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.248 required=5 tests=[AWL=0.167, HTML_30_40=0.056, HTML_MESSAGE=0.001, RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200510/11 X-Sequence-Number: 5773 ------=_Part_34391_13728232.1129162377853 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Yeah, I'm still in the process of reading more of the doc. But my question is mor= e 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 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 > ------=_Part_34391_13728232.1129162377853 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Yeah,

I'm still in the process of reading more of the doc. But my question is mor= e 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 condi= tions?
Is there a way to get those info.?

Thanks!
Fangbing



------=_Part_34391_13728232.1129162377853--