On Wed, 25 Jun 2014 10:24:53 -0400 Andrew Sullivan <ajs@xxxxxxxxxxxxxxx> wrote: > On Wed, Jun 25, 2014 at 03:16:19PM +0100, James Le Cuirot wrote: > > Same problem as stdin, the transactional behaviour is different. > > There is the --single-transaction option but as the man page says... > > > > "If the script itself uses BEGIN, COMMIT, or ROLLBACK, this option > > will not have the desired effects." > > Hmm. I've _used_ transactions in such files, I'm pretty sure. You > don't need the --single-transaction setting for this, just do the > BEGIN; and COMMIT; yourself. > > A Sorry, you're missing the point. I'm trying not to alter the existing behaviour of the Chef database cookbook which is used by countless people to execute scripts big and small, with and without transactions. If I just naively wrapped them all in BEGIN/COMMIT then it would override any additional transactions within the scripts. James
