Re: Does each DBI 'do' start a new transaction?

[talexb]

If you look at the DBI documentation, you'll see that the do method returns a success or failure status. In the code you've posted, you're throwing away that information. Developer Tip: Don't Do That.

Assume that any operation can fail, at any time. As soon as there's a failure, you have to report that error.

[ikegami]

They're using an error handler ($dbh->{HandleError}=\&handle_error;)

[talexb]

I missed that. :( Now, what happens when there's a DBI error inside the error handler? Does it call itself until it hits the 'deep recursion' error? That would be a good place to locally delete the error handler and do something different with that error.