Jan Wieck <JanWieck(at)Yahoo(dot)com> writes:
> On 4/26/2005 3:01 PM, Rob Butler wrote:
>> Are rules even needed anymore? Can't you do this all
>> with triggers? If you want to "DO INSTEAD" just use a
>> row based trigger, and return null. Or is this less
> On INSERT, yes, on UPDATE, how so?
We don't support triggers of any kind on views.
One possibility for an alternative mechanism is to allow triggers on
views --- but I'm not sure exactly how this would work, or if it would
solve all the problems. At the very least it would answer the "data
stability" issue, since I suppose the trigger would receive precomputed
rows that wouldn't change while it executed.
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: David Wheeler||Date: 2005-04-26 20:17:26|
|Subject: Re: DO INSTEAD and conditional rules |
|Previous:||From: Jan Wieck||Date: 2005-04-26 19:14:14|
|Subject: Re: DO INSTEAD and conditional rules|