On Thursday 06 April 2006 03:27 pm, Bill Moseley saith: > On Thu, Apr 06, 2006 at 01:44:57PM -0500, Terry Lee Tucker wrote: > > Triggers fire inside a transaction. > > Ah, thanks. Makes sense since each statement is in an implicit > transaction. > > Granted, would help to see the trigger, but > these are basically the same? > > -- fires a trigger that updates more than one table > insert into semething (default); > > and: > > begin; > -- fires a trigger that updates more than one table > insert into somthing (default); > commit; > In the latter, you have expanded the scope of the transaction; which, sometimes you might want to do.
