Re: Savepoint support proposal

On Wed, 9 Mar 2005 19:34:51 -0800, Jonathan Leffler <[EMAIL PROTECTED]> wrote: > every statement. Besides, I can't stop userrs from using $dbh->do() > to execute BEGIN WORK, COMMIT WORK or ROLLBACK WORK. Or from > preparing and executing them. there's an idea -- restrict what is allowed in $dbh

Re: Savepoint support proposal

FTR: ADO supports nested transactions: The level of nesting may be limited, e.g. Access and Foxpro support 5 levels, Oracle and SQL Server only 1. With some bookkeeping, it should be possible to emulate savepoint

Re: Savepoint support proposal

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > I already got bitten by autocommit (badly; I'm keeping quiet here) - I > already *have* to do a load of analysis and other futzing around with > every statement. Besides, I can't stop userrs from using $dbh->do() > to execute BEGIN WORK, COMMIT WO

Re: Savepoint support proposal

On Thu, Mar 10, 2005 at 10:54:37AM -, Martin J. Evans wrote: > > On 10-Mar-2005 Tim Bunce wrote: > > On Thu, Mar 10, 2005 at 08:54:54AM -, Martin J. Evans wrote: > >> > >> although ODBC does not define what happens if one of the commits on a > >> connection fails (this alone probably make

Re: Savepoint support proposal

For MySQL, the savepoint info is: - Available as of MySQL 4.1.1 for InnoDB transactions. - Set a savepoint with: SAVEPOINT savepoint_name - Rollback syntax accepts optional TO SAVEPOINT clause: ROLLBACK [TO SAVEPOINT savepoint_name]

Re: Savepoint support proposal

On 10-Mar-2005 Tim Bunce wrote: > On Thu, Mar 10, 2005 at 08:54:54AM -, Martin J. Evans wrote: >> >> although ODBC does not define what happens if one of the commits on a >> connection fails (this alone probably makes commiting on an environment >> unpopular if used at all). > > Exactly. Thi

Re: Savepoint support proposal

On Thu, Mar 10, 2005 at 08:54:54AM -, Martin J. Evans wrote: > > although ODBC does not define what happens if one of the commits on a > connection fails (this alone probably makes commiting on an environment > unpopular if used at all). Exactly. This (commit_all etc) won't make it into the D

Re: Savepoint support proposal

On Thu, Mar 10, 2005 at 04:45:06AM -, Greg Sabino Mullane wrote: > > > My position is that I'm open to being persuaded, but you'll have > > to put in the leg work. The best place for that at this stage is > > dbi-users as I'd like you to be able to show wider support for the > > proposals from

Re: Savepoint support proposal

On 10-Mar-2005 Jonathan Leffler wrote: > On Wed, 09 Mar 2005 08:55:21 - (GMT), Martin J. Evans > <[EMAIL PROTECTED]> wrote: >> Just a small point. >> >> I could be wrong (I cannot look it up right now) but I think in ODBC >> SQLEndTran >> can issue a rollback or commit on ALL connections. Eff

Re: Savepoint support proposal

On Wed, 9 Mar 2005 19:34:51 -0800, Jonathan Leffler <[EMAIL PROTECTED]> wrote: > On Wed, 9 Mar 2005 09:47:20 +0100, H.Merijn Brand <[EMAIL PROTECTED]> > wrote: > > On Tue, 8 Mar 2005 12:12:23 -0800, Jonathan Leffler > > <[EMAIL PROTECTED]> wrote: > > > On Tue, 8 Mar 2005 11:01:48 +, Ti

Re: Savepoint support proposal

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > I'd be interested to see how varied the syntax is between databases. I honestly don't know, but I am pretty sure most are standard, with some (DB2?) having extensions, but still supporting the same syntax. > I'd also be interested to see a propos

Re: [dbi] Re: Savepoint support proposal

On Wed, 09 Mar 2005 15:34:24 -0800, Dean Arnold <[EMAIL PROTECTED]> wrote: > Dan Scott wrote: > > On Wed, 9 Mar 2005 13:29:40 -0800, Darren Duncan > > <[EMAIL PROTECTED]> wrote: > > > >>At 8:55 AM + 3/9/05, Martin J. Evans wrote: > >> > >>>Just a small point. > >>>I could be wrong (I cannot loo

Re: [dbi] Re: Savepoint support proposal

On Wed, 09 Mar 2005 08:55:21 - (GMT), Martin J. Evans <[EMAIL PROTECTED]> wrote: > Just a small point. > > I could be wrong (I cannot look it up right now) but I think in ODBC > SQLEndTran > can issue a rollback or commit on ALL connections. Effectively, it issues the > rollback/commit on eac

Re: Savepoint support proposal

On Wed, 9 Mar 2005 09:47:20 +0100, H.Merijn Brand <[EMAIL PROTECTED]> wrote: > On Tue, 8 Mar 2005 12:12:23 -0800, Jonathan Leffler > <[EMAIL PROTECTED]> wrote: > > On Tue, 8 Mar 2005 11:01:48 +, Tim Bunce <[EMAIL PROTECTED]> wrote: > > > On Mon, Mar 07, 2005 at 11:47:32PM -, Greg Sabino Mul

Re: [dbi] Re: Savepoint support proposal

Dan Scott wrote: On Wed, 9 Mar 2005 13:29:40 -0800, Darren Duncan <[EMAIL PROTECTED]> wrote: At 8:55 AM + 3/9/05, Martin J. Evans wrote: Just a small point. I could be wrong (I cannot look it up right now) but I think in ODBC SQLEndTran can issue a rollback or commit on ALL connections. Effecti

Re: [dbi] Re: Savepoint support proposal

On Wed, 9 Mar 2005 13:29:40 -0800, Darren Duncan <[EMAIL PROTECTED]> wrote: > At 8:55 AM + 3/9/05, Martin J. Evans wrote: > >Just a small point. > >I could be wrong (I cannot look it up right now) but I think in ODBC > >SQLEndTran > >can issue a rollback or commit on ALL connections. Effectivel

RE: [dbi] Re: Savepoint support proposal

At 8:55 AM + 3/9/05, Martin J. Evans wrote: Just a small point. I could be wrong (I cannot look it up right now) but I think in ODBC SQLEndTran can issue a rollback or commit on ALL connections. Effectively, it issues the rollback/commit on each connection in the environment. That would be a l

RE: [dbi] Re: Savepoint support proposal

On 08-Mar-2005 Jonathan Leffler wrote: > I'm keeping this on dbi-dev pro tem. Greg - I suggest you ask the > question on dbi-users. > > > On Tue, 8 Mar 2005 11:01:48 +, Tim Bunce <[EMAIL PROTECTED]> wrote: >> On Mon, Mar 07, 2005 at 11:47:32PM -, Greg Sabino Mullane wrote: >> > > While

Re: Savepoint support proposal

On Tue, 8 Mar 2005 12:12:23 -0800, Jonathan Leffler <[EMAIL PROTECTED]> wrote: > I'm keeping this on dbi-dev pro tem. Greg - I suggest you ask the > question on dbi-users. > > > On Tue, 8 Mar 2005 11:01:48 +, Tim Bunce <[EMAIL PROTECTED]> wrote: > > On Mon, Mar 07, 2005 at 11:47:32PM -,

Re: Savepoint support proposal

I'm keeping this on dbi-dev pro tem. Greg - I suggest you ask the question on dbi-users. On Tue, 8 Mar 2005 11:01:48 +, Tim Bunce <[EMAIL PROTECTED]> wrote: > On Mon, Mar 07, 2005 at 11:47:32PM -, Greg Sabino Mullane wrote: > > > While I don't have any particular objections, doesn't > >

Re: Savepoint support proposal

On Mon, Mar 07, 2005 at 11:47:32PM -, Greg Sabino Mullane wrote: > > > 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() > > > > sufficient ? > > Sure, but th

Re: Savepoint support proposal

-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() > > sufficient ? Sure, but they also have syntax to implement BEGIN

Re: Savepoint support proposal

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 > >c

Re: Savepoint support proposal

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

Savepoint support proposal

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 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 li