"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
