Bill Wordsworth wrote: > ...resending, email didn't go through. > > On Tue, Jul 22, 2008 at 1:02 PM, Bill Wordsworth > <[EMAIL PROTECTED]> wrote: >> Is this recommended? >> >> pg_query("begin transaction read write;", $connection); >> if(pg_transaction_status($connection) == 2) { >> pg_query("insert...;", $connection); >> pg_query("insert...;", $connection); >> pg_query("insert...;", $connection); >> } >> pg_query("commit transaction;", $connection); >> pg_close($connection); >> >> Now *any* error inside transaction will trigger auto rollback for >> *all* inserts so I don't need to explicitly issue conditional >> rollback? Also is "begin/commit transaction" == "start/end >> transaction"??
What if something gets an invalid state (eg you expect a record to have 'active = 156' but it's something else). So in some cases yes you'll need to do a rollback. On the other hand, if you don't explicitly do a commit, everything is rolled back. Yes "begin" == "start transaction" and "commit" == "end transaction". -- Postgresql & php tutorials http://www.designmagick.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general