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,
Dean Arnold
Presicient Corp.
