Re: [GENERAL] How do you control IMMUTABLE PG PROC results?

2010-11-04 Thread hubert depesz lubaczewski
On Thu, Nov 04, 2010 at 08:24:14PM -0400, Carlo Stonebanks wrote: > We have procs that would benefit from returning IMMUTABLE results. > The procs are dependent on external tables that rarely change, but > when they DO change, it would be great if we could expire the cache > that the procs read fro

Re: [GENERAL] How do you control IMMUTABLE PG PROC results?

2010-11-04 Thread Leif Biberg Kristensen
On Friday 5. November 2010 01.24.14 Carlo Stonebanks wrote: > We have procs that would benefit from returning IMMUTABLE results. The procs > are dependent on external tables that rarely change, but when they DO > change, it would be great if we could expire the cache that the procs read > from s

[GENERAL] How do you control IMMUTABLE PG PROC results?

2010-11-04 Thread Carlo Stonebanks
We have procs that would benefit from returning IMMUTABLE results. The procs are dependent on external tables that rarely change, but when they DO change, it would be great if we could expire the cache that the procs read from so that the procs are forced to re-evaluate the results. Is this po