Re: What Is The Firing Order? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: What Is The Firing Order?
Date
Msg-id 200109071536.f87FapY28936@candle.pha.pa.us
Whole thread Raw
In response to Re: What Is The Firing Order?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> > I wish the constraint will be fired first.
>
> That seems fairly arbitrary; someone else might wish the opposite,
> depending on the details of what they want to do.
>
> If we were to modify the code to make the firing order predictable,
> I'd want it to be user-controllable.  A simple hack that comes to
> mind is to fire triggers in alphabetical order by name --- then you
> can easily arrange for custom triggers to fall either before or after
> system-generated ones.  But perhaps someone else has a better idea.

This is not the first time someone has asked about firing order.  We
either need a solution or I will add it to the TODO list.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: Jeff Patterson
Date:
Subject: query help
Next
From: wsheldah@lexmark.com
Date:
Subject: Re: Idea: jobs.postgresql.org