| From: | Andreas Kretschmer <akretschmer(at)despammed(dot)com> |
|---|---|
| To: | Postgres Novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: [despammed] Rules and transactions |
| Date: | 2005-07-06 12:13:01 |
| Message-ID: | 20050706121301.GA4735@webserv.wug-glas.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
am 06.07.2005, um 13:34:10 +0200 mailte Reinhard Hnat folgendes:
> 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, its a 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.
I'm not sure: enable stats_command_string in your postgresql.conf
Regards, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47212, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Celia McInnis | 2005-07-06 14:37:10 | array to rows of it's elements? |
| Previous Message | Reinhard Hnat | 2005-07-06 11:34:10 | Rules and transactions |