Steve Petrie, P.Eng. wrote:
> And yes, I am using pg_send_query(...) to execute the BEGIN; command, so as
> to get a result resource returned. (Please see my forthcoming emailed
> response to Adrian Klaver, wherein I provide the PHP source code that Adrian
> requests.)
After successfully calling pg_send_query($cnx, $query),
pg_transaction_status($cnx) will return PGSQL_TRANSACTION_ACTIVE
until the results have been collected by looping over pg_get_result($cnx).
This is for any query, not specifically $query="BEGIN".
Example:
<?php
if (pg_send_query($dbcnx, "BEGIN")) {
do {
$res=pg_get_result($dbcnx);
// error processing here
} while ($res);
echo pg_transaction_status($dbcnx);
?>
This will output 2, which corresponds to PGSQL_TRANSACTION_INTRANS
as expected.
OTOH if commenting the call to pg_get_result($dbcnx), then
it ouputs 1 (PGSQL_TRANSACTION_ACTIVE) as you mentioned.
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite