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

Re: [despammed] Rules and transactions

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 (view raw or flat)
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    === 

In response to

pgsql-novice by date

Next:From: Celia McInnisDate: 2005-07-06 14:37:10
Subject: array to rows of it's elements?
Previous:From: Reinhard HnatDate: 2005-07-06 11:34:10
Subject: Rules and transactions

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