Re: Trigger function volatility - Mailing list pgsql-novice

From Tom Lane
Subject Re: Trigger function volatility
Date
Msg-id 25804.1249434576@sss.pgh.pa.us
Whole thread Raw
In response to Trigger function volatility  (Tyler Mitchell <fission@ldx.ca>)
List pgsql-novice
Tyler Mitchell <fission@ldx.ca> writes:
> Can anyone think of any issues with IMMUTABLE in this case?

It's incorrect.  The function is altering NEW, so I hardly see how you
can think it's immutable --- it has side effects.

The system might let you do this at the moment, because it pays
hardly any attention to the volatility classification of a trigger
function anyhow; but that doesn't make it a good idea.

            regards, tom lane

pgsql-novice by date:

Previous
From: David Powell
Date:
Subject: can long-lived transactions cause problems?
Next
From: Tom Lane
Date:
Subject: Re: can long-lived transactions cause problems?