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.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
