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 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match