"Tom Lane" <tgl@sss.pgh.pa.us> writes:
> beickhof@Lexmark.com writes:
>> Well, I am considering a function that does select from a table, but the
>> table contents change extremely infrequently (the table is practically a
>> list of constants). Would it be safe to declare the function IMMUTABLE
>> provided that the table itself is endowed with a trigger that will drop
>> and recreate the function any time the table contents are modified?
>
> What you'd want to do is restart all existing sessions so that any plans
> made using precomputed function values are discarded. The trigger you
> suggest is fairly pointless because it will not cause regeneration of
> plans.
The trigger would alert him if there were any indexes built using the
function...
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
