X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id A95E6D1C4B8 for ; Wed, 13 Aug 2003 14:54:40 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 30436-02 for ; Wed, 13 Aug 2003 11:53:08 -0300 (ADT) Received: from irko.smoothcorp.com (unknown [208.49.241.41]) by svr1.postgresql.org (Postfix) with ESMTP id 1F174D1B524 for ; Wed, 13 Aug 2003 11:54:29 -0300 (ADT) Received: from [10.0.1.63] (helo=jgardner.smoothcorp.com) by irko.smoothcorp.com with esmtp (Exim 4.12) id 19mx1F-0003JI-00; Wed, 13 Aug 2003 07:54:33 -0700 Received: from jgardner.smoothcorp.com (localhost.localdomain [127.0.0.1]) by jgardner.smoothcorp.com (8.12.8/8.12.8) with ESMTP id h7DEsXsN032377; Wed, 13 Aug 2003 07:54:33 -0700 Received: from localhost (localhost [[UNIX: localhost]]) by jgardner.smoothcorp.com (8.12.8/8.12.8/Submit) id h7DEsW1f032375; Wed, 13 Aug 2003 07:54:32 -0700 From: Jonathan Gardner To: "=?iso-8859-2?q?SZ=DBCS?= =?iso-8859-2?q?=20G=E1bor?=" , Subject: Re: Order of triggers - totally lost Date: Wed, 13 Aug 2003 07:54:30 -0700 User-Agent: KMail/1.5 References: <001001c36183$4f636570$0403a8c0@fejleszt4> In-Reply-To: <001001c36183$4f636570$0403a8c0@fejleszt4> MIME-Version: 1.0 Content-Type: Text/Plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable Content-Description: clearsigned data Content-Disposition: inline Message-Id: <200308130754.32211.jgardner@jonathangardner.net> X-SA-Exim-Rcpt-To: surrano@mailbox.hu, pgsql-sql@postgresql.org X-SA-Exim-Scanned: No; SAEximRunCond expanded to false X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/137 X-Sequence-Number: 14753 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Wednesday 13 August 2003 03:11, SZ=DBCS G=E1bor 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=20 statements and the insert statement that started it all? I get the=20 feeling that you may have more triggers than you really need. - --=20 Jonathan Gardner Live Free, Use Linux! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE/OlEmWgwF3QvpWNwRAnPdAKDEVKuZb+hRuF0VT2XvE2jf/NNlGwCfUnl9 FP6qKYkr8zAokDNaK4CI6rE=3D =3D0kMs -----END PGP SIGNATURE-----