Re: proposal: schema PL session variables

On 08/02/16 13:17, Pavel Stehule wrote:
> 2016-02-08 13:03 GMT+01:00 Marko Tiikkaja <marko@joh.to>:
>> How does this function know which schema variables are visible?
>
> function see all schema variables from same schema as function's schema

Personally I find that undesirable.  I don't know what oracle does, but 
variables being visible without schema-qualifying them can introduce 
variable conflicts in PL/PgSQL.  I'd prefer if you could only refer to 
them by prefixing them with the schema name (or maybe allow search_path 
to be used).


.m