Tranzactii in PostgreSQL with PHP

pepys

My task: I want to use transactions for every query in my application. Something like:

BEGIN
UPDATE facturi SET valoare=540.46 WHERE id = '77'
UPDATE ....
DELETE...
COMMIT;

I'm searching for some functions for verify the query result, in order to execute COMMIT if here isn't any database problem, or ROLLBACK if any problem. Can somebody help me in this problem? Pls.. 10x!

Is somethig about pg_result_status() or pg_result_error() functions from PostgreSQL?

Sxooter

Yep, you can detect an error with pg_last_error or pg_result_error.

Note that you can use savepoints to revert part of a transaction.

Without using savepoints, PostgreSQL will roll back your whole transaction if there is a single error, whether you use commit or rollback.

pepys

Ok, thank you very much! I read about this functions.. but how can I used?

In my db class, i have somethig like this:

function affected_rows($res_id) {
   $fname = $this->pg_affected_rows;
   return @$fname($this->res[$res_id]);            

   }

function affected_rows($res_id="default") {
   return $this->con[$this->default_type]->affected_rows($res_id);
   }

for define the affected_rows() function. Starting from this template, how can I define the pg_result_status() function and how can I use this?

Thanks!