Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id ACF194769AD for ; Wed, 27 Nov 2002 09:40:14 -0500 (EST) Received: from anchor-post-33.mail.demon.net (anchor-post-33.mail.demon.net [194.217.242.91]) by postgresql.org (Postfix) with ESMTP id 8B0E24764C4 for ; Wed, 27 Nov 2002 09:15:45 -0500 (EST) Received: from lfix.demon.co.uk ([158.152.59.127] helo=linda.lfix.co.uk) by anchor-post-33.mail.demon.net with esmtp (Exim 3.35 #1) id 18H2yj-00050c-0X; Wed, 27 Nov 2002 14:15:49 +0000 Received: from localhost ([127.0.0.1] ident=olly) by linda.lfix.co.uk with esmtp (Exim 3.36 #1 (Debian)) id 18H2yi-0001wj-00; Wed, 27 Nov 2002 14:15:48 +0000 Subject: Re: Handling SQL errors using libpq From: Oliver Elphick To: William Brennan Cc: pgsql-interfaces@postgresql.org In-Reply-To: References: Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-NWXVRcnN9MlZEelIJ7o6" Organization: LFIX Limited Message-Id: <1038406548.13294.91.camel@linda.lfix.co.uk> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.0 Date: 27 Nov 2002 14:15:48 +0000 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/147 X-Sequence-Number: 3395 --=-NWXVRcnN9MlZEelIJ7o6 Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Thu, 2002-11-21 at 18:37, William Brennan wrote: > After a call to libpq, I would like to be able to recognize specific=20 > SQL errors which might occur, beyond the simple results obtainable > via a call to PQresultStatus(). I want more precision. You can get the actual error message with PQresultErrorMessage()=20 --=20 Oliver Elphick LFIX Limited --=-NWXVRcnN9MlZEelIJ7o6 Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQA95NOUYU1MND4dDBwRAuuAAJ4sqK/w2hCyMUHHF9FizIo3vBL5QACfewma QsbYOCFGAfn2hP7ToJOdezQ= =+OdI -----END PGP SIGNATURE----- --=-NWXVRcnN9MlZEelIJ7o6--