Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 014C49FB9DD for ; Sat, 21 Apr 2007 06:56:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 59442-05 for ; Sat, 21 Apr 2007 06:56:20 -0300 (ADT) X-Greylist: delayed 00:16:44.398458 by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 32F7E9FB645 for ; Sat, 21 Apr 2007 06:56:24 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mailfilter1.7data.eu (82-100-4-5.net.maiva.cz [82.100.4.5]) by svr4.postgresql.org (Postfix) with ESMTP id 09BF65AF028 for ; Sat, 21 Apr 2007 09:39:38 +0000 (GMT) Received: from mailfilter1.7data.eu (localhost [127.0.0.1]) by sagator.mailfilter1.7data.eu (Postfix) with ESMTP id 6692F499B64 for ; Sat, 21 Apr 2007 11:39:20 +0200 (CEST) X-Sagator-Scanner: 0.8.1-1 at 7drouter1; log(status(quarantine(drop(stream2mbox(libclam())))), status(quarantine(drop(SpamAssassinD())))) X-Sagator-ID: 20070421-113920-0001-13837-m201Vc@7drouter1 Received: from [192.168.100.100] (unknown [192.168.100.100]) by mailfilter1.7data.eu (Postfix) with ESMTP id 55667499B63 for ; Sat, 21 Apr 2007 11:39:20 +0200 (CEST) Message-ID: <4629DBC8.4010700@7data.eu> Date: Sat, 21 Apr 2007 11:39:20 +0200 From: David Pufer User-Agent: Thunderbird 2.0.0.0 (X11/20070420) MIME-Version: 1.0 To: pgsql-docs@postgresql.org Subject: Improving CREATE CONSTRAINT TRIGGER documentation - trigger firing order Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.136 tagged_above=0 required=5 tests=BAYES_50=0.001, FORGED_RCVD_HELO=0.135, UPPERCASE_25_50=0 X-Spam-Level: X-Archive-Number: 200704/19 X-Sequence-Number: 4215 Hello docs hackers, In my opinion it would be nice to mention in SQL reference commands that constraint triggers created by CREATE CONSTRAINT TRIGGER are fired in creation order unlike regular triggers created by command CREATE TRIGGER. As I know, the firing order of the CONSTRAINT TRIGGER is determined by the XXXXX num at "RI_ConstraintTrigger_XXXXX" column in pg_trigger table. Regards, David Pufer