Re: proposal: schema PL session variables

>> I didn't propose SESSION variables - now there are some workarounds how
>> to anybody can emulate it, so this feature can wait. What we need is
>> safe session variables with limited access. And the border can be
>> defined by schema scope. So the keyword SCHEMA has sense, and it is
>> necessary.
>>
>
> BTW, if all that's desired here are session variables for plpgsql, I think
> it makes a lot more sense to start with implementing per-function session
> variables. That's a lot simpler design-wise and is something we should have
> anyway. You don't necessarily want session variables to be schema-level. (I
> realize the other PLs make them global, which is even worse, but that's no
> reason to continue that path.)

I am not able to implement SET and GET content in one function effectively.
I believe so static variables can be enough for 50%, but it is too limited.
Postgres cannot to pass and work with references, so this C design can be
too expensive.

Regards

Pavel

>
> --
> Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
> Experts in Analytics, Data Architecture and PostgreSQL
> Data in Trouble? Get it in Treble! http://BlueTreble.com
>