Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group