Rules and transactions

From: "Reinhard Hnat" <hnat(at)logotronic(dot)co(dot)at>
To: "Postgres Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Rules and transactions
Date: 2005-07-06 11:34:10
Message-ID: 002301c5821e$a42d0210$0163a8c0@hnat
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andreas Kretschmer 2005-07-06 12:13:01 Re: [despammed] Rules and transactions
Previous Message David 2005-07-06 02:58:33 Backups - WAL archiving. problem understanding documentation