Re: Order of evaluation in triggers for checks on inherited table partitions - Mailing list pgsql-sql

From Tarlika Elisabeth Schmitz
Subject Re: Order of evaluation in triggers for checks on inherited table partitions
Date
Msg-id 20110527205242.1a832501@dick.coachhouse
Whole thread Raw
In response to Order of evaluation in triggers for checks on inherited table partitions  (Kevin Crain <kevin.crain1@gmail.com>)
List pgsql-sql
On Fri, 27 May 2011 12:28:51 -0700
Kevin Crain <kevin.crain1@gmail.com> wrote:

>Is the order of evaluation for the trigger causing this error?

Are you aware that triggers are executed in alphabetical order?

I simply used RAISE to check the order of execution of my triggers:

RAISE NOTICE '% % % %: received %', TG_TABLE_NAME, TG_NAME, TG_WHEN,
TG_OP, NEW;



pgsql-sql by date:

Previous
From: Kevin Crain
Date:
Subject: Order of evaluation in triggers for checks on inherited table partitions
Next
From: Piotr Czekalski
Date:
Subject: Re: Re: 500KB PDF files for postgresql8.3, which is the most efficient way?