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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | operationsengineer1 | 2005-07-06 16:01:56 | Re: Aliased table names ...oddity? |
Previous Message | Celia McInnis | 2005-07-06 14:37:10 | array to rows of it's elements? |