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

From Bruce Momjian
Subject Re: What Is The Firing Order?
Date
Msg-id 200109072001.f87K1kv20378@candle.pha.pa.us
Whole thread Raw
In response to Re: What Is The Firing Order?  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: What Is The Firing Order?
List pgsql-general
> > That seems fairly arbitrary; someone else might wish the opposite,
> > depending on the details of what they want to do.
>
> We should probably check first whether the SQL standard has anything to
> say about the relative ordering of foreign key cascade actions versus
> triggers.  (I would tend to think that triggers come after FK actions.
> However, things might get tricky when cascade actions fire triggers of
> their own.)
>
> The order of execution of "pure" triggers meanwhile is defined thus:
>
>          The order of execution of a set of triggers is ascending by value
>          of their timestamp of creation in their descriptors, such that the
>          oldest trigger executes first. If one or more triggers have the
>          same timestamp value, then their relative order of execution is
>          implementation-defined.  [4.35]
>
> This is probably what happens in practice anyway, so it might make sense
> to follow this rule.

Yep, that would be a pretty strong vote for OID order.

--
  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: "Brent R. Matzelle"
Date:
Subject: Re: moving char() to varchar()
Next
From: Alex Pilosov
Date:
Subject: Re: moving char() to varchar()