| 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: | Whole Thread | Raw Message | 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 |