[DB-SIG] Python 2.0 DB Api - Threading and Transactions not known until connected

[Christopher Petrilli]

On Wed, Aug 25, 1999 at 04:49:14PM -0400, Andy Dustman wrote:
> 
> In standard SQL, a transaction begins once you start executing SQL
> statements (there's probably a more rigorous definition of this), and ends
> when you execute COMMIT WORK or ROLLBACK WORK. There's no command that
> explicitely begins a transaction.

Well, this isn't entirely accurate :-)  Sybase has a "begin
transaction", and Oracle requires a "select for update" if you wish to
do any form of locking. Otherwise, you're working in parallel versions
and you're doing dirty reads.  SQL is great for trivial things, but it's
not that standard quite honestly.

Chris
-- 
| Christopher Petrilli                      ``Television is bubble-gum for
| petrilli@amber.org                          the mind.''-Frank Lloyd Wright