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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Hallgren <thhal(at)mailblocks(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: UPDATE is not allowed in a non-volatile function
Date: 2004-11-03 21:08:45
Message-ID: 16960.1099516125@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Thomas Hallgren <thhal(at)mailblocks(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-11-03 21:21:37 Re: tablespaces for temporary files
Previous Message Bruce Momjian 2004-11-03 20:23:26 Pre-8.0 outstanding patches