| 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: | Whole Thread | Raw Message | 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? |