Thread: Error reporting

Error reporting

From
dDave
Date:
Hi,

I use PG 7.4 and adoDB library with PHP to develop. Recently I noticed
errors were being logged in my /var/log/messages for Postgresql
errors, however, my transactions were not bombing out as expected.

A simple example:

$sql = "SELECT my_pgsql_function($x,$y)";

$db->BeginTrans();
$rs=$db->Execute($sql);
if(!$rs) {
    trigger_error($db->ErrorMsg());
    $db->RollbackTrans();
    exit;
} else {
    $db->CommitTrans();
}

Oddly enough, if the function my_pgsql_function() does not exist in
the pg_catalog, Postgresql reports the error to the messages file no
problem.

BUT, my $rs is not being set to false or NULL and hence the code tries
to commit a transaction, but, that is not right, since the log also
provides a message that it tried to commit a non-valid transaction???

Is there a method to the madness of postgresql errors I am missing
here with adodb???

Dave