public inbox for [email protected]  

help / color / mirror / Atom feed

From: David Pufer <[email protected]>
To: [email protected]
Subject: Re: Improving CREATE CONSTRAINT TRIGGER documentation - trigger firing order
Date: Sat, 21 Apr 2007 18:02:13 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>

Michael Glaesemann wrote:
>
> On Apr 21, 2007, at 4:39 , David Pufer wrote:
>
>> 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.
>
> I believe this just falls out of the normal order of trigger firing as
> explained in the CREATE TRIGGER documentation
> (http://www.postgresql.org/docs/8.2/interactive/sql-createtrigger.html)
>
>> If multiple triggers of the same kind are defined for the same event,
>> they will be fired in alphabetical order by name.
>
> It might be nice to add a similar phrase to the CREATE CONSTRAINT
> TRIGGER documentation, but as far as I know, the behavior is the same
> for triggers created by either method. The only difference is that
> constraint triggers are named by the system rather than by the user.
>
> Thoughts?
>
> Michael Glaesemann
> grzm seespotcode net
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

You are right. Thanks for the note of system name that are assigned by
the server by incrementing the num at "RI_ConstraintTrigger_NUM" at each
constraint trigger creation.

Regards,
David Pufer

view thread (6+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: Improving CREATE CONSTRAINT TRIGGER documentation - trigger firing order
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox