Thread: Rules and transactions

Rules and transactions

From
"Reinhard Hnat"
Date:
Does anybody know how the following exactly works: If i use autocommit and
create a rule which has two or more SQL statements in it's action part, are
these executed within one single transaction?
Second question: it would be helpful to see which statements are executed
acutally when executing a rule. Which settings should i use to see it in
syslog.

Thanks in advance
----
R.Hnat



Re: [despammed] Rules and transactions

From
Andreas Kretschmer
Date:
am  06.07.2005, um 13:34:10 +0200 mailte Reinhard Hnat folgendes:
> Does anybody know how the following exactly works: If i use autocommit and
> create a rule which has two or more SQL statements in it's action part, are
> these executed within one single transaction?

Yes, its a single transaction.


> Second question: it would be helpful to see which statements are executed
> acutally when executing a rule. Which settings should i use to see it in
> syslog.

I'm not sure: enable stats_command_string in your postgresql.conf


Regards, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

Re: Rules and transactions

From
Tom Lane
Date:
"Reinhard Hnat" <hnat@logotronic.co.at> writes:
> Does anybody know how the following exactly works: If i use autocommit and
> create a rule which has two or more SQL statements in it's action part, are
> these executed within one single transaction?

Yes.

> Second question: it would be helpful to see which statements are executed
> acutally when executing a rule. Which settings should i use to see it in
> syslog.

You can't, mainly because those statements are never constructed in
textual form.  You could use EXPLAIN to get some impression of what's
going on though.

            regards, tom lane