Re: plgpsql and transactions - Mailing list pgsql-general

From Bill Moseley
Subject Re: plgpsql and transactions
Date
Msg-id 20060406192707.GC9347@hank.org
Whole thread Raw
In response to Re: plgpsql and transactions  (Terry Lee Tucker <terry@esc1.com>)
Responses Re: plgpsql and transactions
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


pgsql-general by date:

Previous
From: "Silas Justiniano"
Date:
Subject: Queries with Regular Expressions
Next
From: David Gama Rodrí­guez
Date:
Subject: %Re: % tsearch gendict