Message-ID: <003e01c361b1$37d02780$0403a8c0@fejleszt4>
From: "=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?=" <surrano@mailbox.hu>
To: <pgsql-sql@postgresql.org>
References: <001001c36183$4f636570$0403a8c0@fejleszt4>
	<200308130754.32211.jgardner@jonathangardner.net>
Subject: Re: Order of triggers - totally lost
Date: Wed, 13 Aug 2003 17:40:26 +0200
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-2"
Content-Transfer-Encoding: 8bit

Dear Jonathan,

Thanks for your will to help.

It would be a bit difficult to clean up everything as much as possible
(while keeping the problem) and send the skeleton.

It looks like the A_AU trigger I mentioned solved the problem.

Actually, the situation I painted is much much simplified compared to the
real one (about 20 or more tables are accessed during that "simple 1-line
update"). What I'd probably use best, are some generic guidelines:

 * what is sure about trigger execution order?
   (Cristoph Haller partially answered my question, quoting future plans)
 * are there generic recommendations what kind of things to put in
   before and after triggers?
 * how about FOR EACH STATEMENT triggers?
   (we only use FOR EACH ROW triggers)

G.
------------------------------- cut here -------------------------------
----- Original Message ----- 
From: "Jonathan Gardner" <jgardner@jonathangardner.net>
Sent: Wednesday, August 13, 2003 4:54 PM


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wednesday 13 August 2003 03:11, SZŰCS Gábor wrote:
>
> What may be wrong? Any ideas to re-organize parts of the triggers?
> May putting the update to an A_AU trigger help? I tried it, still
> have problems (not sure it's still the trigger order), but the
> trigger order is still strange for me:

I'd need some solid code to solve this. Can you send the create
statements and the insert statement that started it all? I get the
feeling that you may have more triggers than you really need.