Subject: Re: debug a mess
From: Matthew Vanecek <mevanecek@yahoo.com>
To: Postgresql Interfaces List <pgsql-interfaces@postgresql.org>
In-Reply-To: <20030225134154.A23392@example.com>
References: <20030225134154.A23392@example.com>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="=-xo7eVfRurm9+8SdSlxIw"
Organization: 
Message-Id: <1046204996.12261.65.camel@reliant.home.pri>
Mime-Version: 1.0
Date: 25 Feb 2003 14:29:56 -0600

--=-xo7eVfRurm9+8SdSlxIw
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

On Tue, 2003-02-25 at 12:41, Wei Weng wrote:
> I am trying to figure out where the "NOTICE:  current transaction is abor=
ted,
> queries ignored until end of transaction block" comes from in my code.
> Basically, this is what it does:
>=20
> CString strQuery=20
> =3D "SELECT datname FROM pg_database WHERE name =3D 'mydatabase'";
>=20
> if (NULL =3D=3D (res =3D PQexec(pgconn, (CSTR) strQuery)))
> {
>     ErrorQuit(PQerrorMessage(pgconn));
> }
>=20
> It is really very simple code, but each time I try to run it, the postgre=
sql
> backend gives me the "transaction aborted" error message. I checked the
> mailing list archive, and Tom once explained that the reason for this err=
or
> message is the backend had quitted for some reason. Is there anyway to see
> why the backend aborted the transaction?? It could be really helpful.
>=20

It sounds like you've executed a query or command, and have not called
PQclear(result) on the results.  Whenever I've gottten that error, not
clearing the results has always been the root cause.  Make sure result
is not NULL first, of course...


--=20
Matthew Vanecek
perl -e 'print $i=3Dpack(c5,(41*2),sqrt(7056),(unpack(c,H)-2),oct(115),10);'
***************************************************************************=
*****
For 93 million miles, there is nothing between the sun and my shadow except=
 me.
I'm always getting in the way of something...

--=-xo7eVfRurm9+8SdSlxIw
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQA+W9JDi/CNzDSN0RIRAi+eAJ9v2kG+wPexPuW7diwAdNgkzSFzAQCffW8b
mbsDCq4tGrwWnBBf7kwOSrA=
=Q682
-----END PGP SIGNATURE-----

--=-xo7eVfRurm9+8SdSlxIw--