From: | Frank van Vugt <ftm(dot)van(dot)vugt(at)foxi(dot)nl> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | PL/pgSQL : notion of deferred execution |
Date: | 2005-12-11 15:31:59 |
Message-ID: | 200512111631.59211.ftm.van.vugt@foxi.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
L.S.
I'd like to prevent updates on a specific field when done during regular use
or during the execution of any non-deferred trigger, while allowing them when
done from deferred triggers. (BTW, we're talking version 8.1 here).
Currently there doesn't seem to be a way to know whether code is executed
during a regular trigger call or during a deferred trigger call? I.e.
something in the line of TG_WHEN and a bit more to the point then looking
whether TG_ARGV[] contains the deferred keywords.....
So, am I overlooking a way to get to this info? And if not, could this be
considered an item for the todo list?
Ratio: when deferred triggers on table A are used to calculate field values of
table B (which then obviously need an update), one might want to prevent
direct updates on these fields of table B
--
Best,
Frank.
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2005-12-11 15:41:27 | Re: Performance large tables. |
Previous Message | William Yu | 2005-12-11 15:25:16 | Re: Performance large tables. |