Calling a trigger from a trigger

From: Mike Finn <mike(dot)finn(at)tacticalExecutive(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Calling a trigger from a trigger
Date: 2002-03-11 18:19:00
Message-ID: a6isdp$16j7$1@jupiter.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I have a number of tables that have a group of fields in common.
I want to process theses fields in a before trigger (before insert or
update), but each of the tables have before triggers for processing of
other non-common data fields.

It seems that from a pl/pgsql trigger I cannot call another trigger (the
one that would be common to all) and if I just attach the common trigger as
a second trigger to each table then (according to the docs) there is no
guarantee of the execution order (which I need ... each table requires the
common stuff to be processed before the non-common stuff).

Is there a way to achieve this requirement without duplicating the code
from the common-part in each of table triggers?

Thanks, in advance, for any thoughts
Mike.

=========================================
Mike Finn
mike(dot)finn(at)tacticalExecutive(dot)com

Browse pgsql-sql by date

  From Date Subject
Next Message Hunter, Ray 2002-03-11 19:45:54 Pg_dump
Previous Message Aguinaldo Fagundes Junior 2002-03-11 14:37:12 Timestamp with time zone problem