Re: Order of evaluation in triggers for checks on inherited table partitions

From: Tarlika Elisabeth Schmitz <postgresql3(at)numerixtechnology(dot)de>
To:
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Order of evaluation in triggers for checks on inherited table partitions
Date: 2011-05-27 19:52:42
Message-ID: 20110527205242.1a832501@dick.coachhouse
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Fri, 27 May 2011 12:28:51 -0700
Kevin Crain <kevin(dot)crain1(at)gmail(dot)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;

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Piotr Czekalski 2011-05-28 07:58:29 Re: Re: 500KB PDF files for postgresql8.3, which is the most efficient way?
Previous Message Kevin Crain 2011-05-27 19:28:51 Order of evaluation in triggers for checks on inherited table partitions