Re: plgpsql and transactions - Mailing list pgsql-general

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;




--
Bill Moseley
moseley@hank.org