Re: undefined behaviour for sub-transactions?

Jochen Wiedmann <jochen.wiedmann@xxxxxxxxx> wrote:
> > Is there a way to ask DBI if it is already in a transaction?
> Read the AutCommit flag. :-)

It says,

Enable transactions (by turning "AutoCommit" off) until the next
call to "commit" or "rollback". After the next "commit" or "roll-
back", "AutoCommit" will automatically be turned on again.
If "AutoCommit" is already off when "begin_work" is called then it
does nothing except return an error. If the driver does not support
transactions then when "begin_work" attempts to set "AutoCommit"
off the driver will trigger a fatal error.

However, when using the DBD::Pg driver, begin_work only triggers an error if
the driver was *initialized* with AutoCommit off, and if you begin_work with
AutoCommit on, the next query to $dbh->{AutoCommit} still returns true, and
transactions nest successfully. So is the DBD::Pg driver in error then? (In
other words, there's no support for nested transactions in DBI at all?)

- Tyler
.

Relevant Pages

  • AutoCommit and DBI::Proxy driver
    ... I have the mySQL server, to which I am connecting through DBI::Proxy. ... I don't see any errors or warnings). ... The error says that AutoCommit is not supported by my ... When I connect to mySQL server directly (using 'mysql' driver) everything ...
    (perl.dbi.users)
  • Re: AutoCommit and DBI::Proxy driver
    ... $dbh->begin_work') for the SECOND time (after the first call to ... The error says that AutoCommit is not supported by my ... driver. ... or rollback. ...
    (perl.dbi.users)
  • Re: New Endo
    ... along with depression and other mental variations ... what triggers it. ... As an example, I taught my kids to drive like me, as ... My driving instructor reckoned I'd make a good rally driver as I had ...
    (alt.support.diabetes)
  • RE: bug seen with dynticks from CONFIG_HARDIRQS_SW_RESEND
    ... interrupt or fake interrupt though resend_irq will touch the timer code ... -0- Users space does an ioctl to driver ... -5- This triggers a check for softirq/tasklets ... This is the original ARM dyntick stuff, ...
    (Linux-Kernel)
  • Re: Disassembling Road Blasters steering wheel handles?
    ... triggers, I just use an allen key to get them loose and then I spin ... the right size and turn them out with that, but without the driver ...
    (rec.games.video.arcade.collecting)