Re: proposal: schema PL session variables - Mailing list pgsql-hackers

From Marko Tiikkaja
Subject Re: proposal: schema PL session variables
Date
Msg-id 56B8889A.90604@joh.to
Whole thread Raw
In response to Re: proposal: schema PL session variables  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: proposal: schema PL session variables
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: proposal: schema PL session variables
Next
From: Michael Paquier
Date:
Subject: Re: remove wal_level archive