Re: Help with RULES - Please!

"Jeanna Geier" <jgeier(at)apt-cafm(dot)com> writes:
> Here is my elementdata.measurement View (as stored in Case Studio):
> Create view "elementdata"."measurement" As
> ...
> And here is the update_measurement RULE (as stored in Case Studio):
> CREATE RULE update_measurement AS ON UPDATE
> TO elementdata.measurement
> DO INSTEAD (UPDATE element SET height = (new.height_lin / (SELECT
> ...

That rule should certainly trap any attempted update to
elementdata.measurement. I suppose the error message is being thrown
about some other view ... it's unfortunate that it doesn't tell you
which one :-(. Anyway the message definitely indicates an attempted
update against some view that has not got an unconditional ON UPDATE DO
INSTEAD rule, and this one does.

regards, tom lane