Re: postgres transactions & php

Precedence: bulk Hello moshe, On 21-Jun-00 19:54:57, you wrote: >how i call 2 function of pg_exec() but the posgres wait with the update >for other conections for the second call. In PostgreSQL you start a transaction executing the SQL statement "BEGIN", then you end it by executing "COMMIT" or "ROLLBACK" in the case you want to abort the transaction or there was an error. >does some one can point my to good article in the net about this >subject? You may want to look in the documentation of Metabase, a PHP database abstraction package, that explains the basics of how transactions work. With Metabase transactions are implicitly started by disabling the auto-commit mode, that is wether you are using PostgreSQL or any other transaction capable database. You may find obtain Metabase for free here: http://phpclasses.UpperDesign.com/browse.html/package/20 Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org -- E-mail: mlemos@acm.org URL: http://www.mlemos.e-na.net/ PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp --