Re: UPDATE is not allowed in a non-volatile function

Gaetano Mendola <mendola@bigfoot.com> writes:
> The fact that a non-volatile function can not perform
> update is a good improvement but on the other side will
> limit too much if I know what I'm doing.

I've got zero sympathy for this argument.  It's been documented right
along that functions with side-effects must be marked volatile.  You
don't have a lot of room to complain because 8.0 started to enforce that.

In practice you can circumvent the restriction by splitting the
function in two (ie, there is no check that a nonvolatile function
doesn't call any volatile functions).  So if you insist on sticking
with an unsafe application design, you can do it with relatively
localized changes.
        regards, tom lane