-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

  
> 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 ?
  
Sure, but they also have syntax to implement BEGIN and ROLLBACK.
I see the savepoints as an extension of the same sort of
transaction processing the DBI dos there. Certainly, drivers are
welcome to implementit any way they want (including allowing
savepoints via "do") but the advantages include being able to
track the savepoints closely, even allowing things like returning
an array of the current savepoints to the application. It also
abstracts the savepoint manipulation away from knowing the exact
SQL for your particular DBMS, one of the goals of DBI after all. :)

- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200503070020
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iD8DBQFCK+S/vJuQZxSWSsgRAsWoAKCpoHsJrjzd9z/tcUMiST1W3CRywgCeP3oy
7VN7ahnLVwVLCFU+PF/IXrI=
=KDYY
-----END PGP SIGNATURE-----


Reply via email to