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