Re: plgpsql and transactions

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.