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

[GENERAL] transactions in multiple action rules

2004-12-20 Thread Ron Peterson
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 that's because they are superfluous in that context... ? (I want to be sure that I can cou