Re: DBI/DBD::Pg and transactions - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: DBI/DBD::Pg and transactions
Date
Msg-id 4e757c14c8b8be5e2f5d19c119ae88ae@biglumber.com
Whole thread Raw
In response to DBI/DBD::Pg and transactions  ("Roderick A. Anderson" <raanders@acm.org>)
Responses Re: DBI/DBD::Pg and transactions
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


>Will a $sth->execute()
> of a "SELECT ... FOR UPDATE" statement allow me to update the selected
> records using
> $uth->execute( ... )
> if $sth and $uth are both created/prepared from the same database handle
> "$dbh"?

You are allowed to update either way, but the lock created by the first
execute will be in place for the second, as long as those statement handles
are from the same $dbh (database handle). In general, connecting via DBI
always gives you one connection unless you explicitly create a second one
by calling DBI->connect.

- --
Greg Sabino Mullane greg@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 200707181533
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8


-----BEGIN PGP SIGNATURE-----

iD8DBQFGnmspvJuQZxSWSsgRAxjIAJ0TRN5bTs9s1/Z3/YC/rzGdpEhWiACg11Ca
sdXpTplc1laTXywTrd+8nBw=
=5iA0
-----END PGP SIGNATURE-----



pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: monthly tally of new memberships
Next
From: brian
Date:
Subject: Re: monthly tally of new memberships