Re: UPDATE is not allowed in a non-volatile function - Mailing list pgsql-hackers

From Tom Lane
Subject Re: UPDATE is not allowed in a non-volatile function
Date
Msg-id 16960.1099516125@sss.pgh.pa.us
Whole thread Raw
In response to Re: UPDATE is not allowed in a non-volatile function  (Thomas Hallgren <thhal@mailblocks.com>)
Responses Re: UPDATE is not allowed in a non-volatile function  (Thomas Hallgren <thhal@mailblocks.com>)
Re: UPDATE is not allowed in a non-volatile function  (Gaetano Mendola <mendola@bigfoot.com>)
List pgsql-hackers
Thomas Hallgren <thhal@mailblocks.com> writes:
> The Rationale for my opinion is that since there is a need to accomplish 
> what Gaetano needs, there should be declarative power to express it and 
> thus, prevent "unsafe" designs. We need a way to declare a function 
> "stable with no _intrusive_ side effects".

What you think is non-intrusive may not be so at the database's level.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Pre-8.0 outstanding patches
Next
From: Tom Lane
Date:
Subject: Re: tablespaces for temporary files