Re: Order of triggers - totally lost

From: Jonathan Gardner <jgardner(at)jonathangardner(dot)net>
To: " SZŰCS =?iso-8859-2?q?=20G=E1bor?=" <surrano(at)mailbox(dot)hu>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Order of triggers - totally lost
Date: 2003-08-13 14:54:30
Message-ID: 200308130754.32211.jgardner@jonathangardner.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

-----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.

- --
Jonathan Gardner <jgardner(at)jonathangardner(dot)net>
Live Free, Use Linux!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE/OlEmWgwF3QvpWNwRAnPdAKDEVKuZb+hRuF0VT2XvE2jf/NNlGwCfUnl9
FP6qKYkr8zAokDNaK4CI6rE=
=0kMs
-----END PGP SIGNATURE-----

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message SZŰCS Gábor 2003-08-13 15:40:26 Re: Order of triggers - totally lost
Previous Message Jonathan Gardner 2003-08-13 14:50:41 Re: How to speeed up the query performance