From: William West <wwest@csc.com>
To: pgsql-interfaces@postgresql.org
Subject: Meaning of/ handling of ECPG_NOTICE_* ??
Date: Wed, 25 Sep 2002 16:35:28 -0400
Message-ID: <OF49D4B69F.57A256B5-ON85256C3F.006CE9B1@com> (raw)
I have some ECPG based error recovery functions
that can issue explicit BEGIN and ROLLBACK or COMMIT
on a blind basis under some conditions. That is, BEGIN
can sometimes be issued while already in a transaction,
and ROLLBACK or COMMIT can sometimes be issued
while not in a transaction.
It seems that I sometimes get the resulting
ECPG_NOTICE_[IN/NO]_TRANSACTION
as the sqlca.sqlcode report in my *next* INSERT/
UPDATE/ SELECT/ FETCH, rather than in sqlca.sqlcode
for the BEGIN/ ROLLBACK/COMMIT command?
Is this possible?
I am not doing anything on an asynchronous basis, at least
not on purpose. If it *is* possible, how do I tell when the
sqlca.sqlcode response for the INSERT/ UPDATE/SELECT/
FETCH command has arrived? What should I do with the
NOTICE (apparently coming from the earlier BEGIN/
ROLLBACK/COMMIT) other than log it?
[PostgreSQL 7.2.1 and ECPG 2.9.0, on RedHat 7.2, using
Unix Domain connections exclusively]
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: wwest@csc.com
Subject: Re: Meaning of/ handling of ECPG_NOTICE_* ??
In-Reply-To: <OF49D4B69F.57A256B5-ON85256C3F.006CE9B1@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