Volkan YAZICI wrote:
> Hi,
>
> I was taking a look at _SHARED variable implementation of different
> PLs and it looks like every PL implements its own ad-hoc method to
> preserve cluster-wise data. Wouldn't it be beneficial to have a
> cluster-wise table (sytem catalog?) which is accessible by any
> procedure with required (superuser?) privileges? With such a table,
> procedures (and PLs) will be able to preserve their state data
> natively without need of any ad-hoc method and because of we're using
> a just yet another plain table, all of the MVCC related stuff will be
> handled by PostgreSQL easily.
>
>
The data might well be PL and session specific, though. e.g. a perl
function ref would be both.
I don't know what state we would want to preserve across sessions anyway.
Let's see a use case that a plain user level table wouldn't serve.
cheers
andrew