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

Re: Rules and transactions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Reinhard Hnat" <hnat(at)logotronic(dot)co(dot)at>
Cc: "Postgres Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Rules and transactions
Date: 2005-07-06 14:46:57
Message-ID: 26279.1120661217@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
"Reinhard Hnat" <hnat(at)logotronic(dot)co(dot)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

In response to

pgsql-novice by date

Next:From: operationsengineer1Date: 2005-07-06 16:01:56
Subject: Re: Aliased table names ...oddity?
Previous:From: Celia McInnisDate: 2005-07-06 14:37:10
Subject: array to rows of it's elements?

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