"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?
> 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
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: operationsengineer1||Date: 2005-07-06 16:01:56|
|Subject: Re: Aliased table names ...oddity?|
|Previous:||From: Celia McInnis||Date: 2005-07-06 14:37:10|
|Subject: array to rows of it's elements?|