RE: [PHP-DB] postgres transactions & php

Another good but light reference for transactions is the following: http://www.amazon.com/exec/obidos/ASIN/1558604154/qid=962121564/sr=1-1/104-0020125-5871157 >-----Original Message----- >From: Manuel Lemos [mailto:mlemos@acm.org] >Sent: Monday, June 26, 2000 7:57 PM >To: moshe >Cc: php-db@lists.php.net >Subject: Re: [PHP-DB] 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 >-- > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net >For additional commands, e-mail: php-db-help@lists.php.net >To contact the list administrators, e-mail: >php-list-admin@lists.php.net >