Re: [GENERAL] transactions in multiple action rules

2004-12-20 Thread Tom Lane
Ron Peterson <[EMAIL PROTECTED]> writes: > Do the multiple actions within a multiple action rule implicitly reside > within a transaction? Yes. In the current code it is actually not possible for a single SQL command issued by the client to give rise to more than one transaction. (This might chan

Re: [GENERAL] transactions in multiple action rules

2004-12-20 Thread Bruno Wolff III
On Mon, Dec 20, 2004 at 23:15:39 -0500, Ron Peterson <[EMAIL PROTECTED]> wrote: > Do the multiple actions within a multiple action rule implicitly reside > within a transaction? I notice that if I brace my multiple actions with > BEGIN; and COMMIT;, that I get a syntax error, so I'm assuming tha