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
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 |