On Sun, Mar 06, 2005 at 08:41:01PM -0800, Dean Arnold wrote: > Greg Sabino Mullane wrote: > > > >We are working on implementing savepoint support in DBD::Pg, and > >someone pointed out (quite rightly) that perhaps there should be > >DBI method support for savepoints, as they are a standard SQL > >construct used by more than just PostgreSQL. So I would like to > >propose that DBI implement a savepoint, release, and rollbackto > >method, similar to the existing begin, commit, and rollback > >methods for database handles. In short, these would be simple > >wrappers, with the actual implementation left to the DBDs. I can > >whip up a prototype and more detailed docs, but wanted to see if > >there was any input or objections before I did. > > > >Thanks, > >- -- > >Greg Sabino Mullane [EMAIL PROTECTED] > > While I don't have any particular objections, doesn't > Pg (and most other DBMSs supporting savepoints) have > SQL syntax to implement them ? If so, isn't just > > $dbh->do(<savepoint-sql>) > > sufficient ? > > my 2 cents,
Mine too. The only significant reason I can see for a specific API for savepoints would be to support distributed transaction management (ala XA). If that is the only significant reason then any API proposals should be made in that context. Tim.
