From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Regina Obe <lr(at)pcorp(dot)us>, Andreas Karlsson <andreas(at)proxel(dot)se>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Is there a way around function search_path killing SQL function inlining? |
Date: | 2016-08-12 19:25:05 |
Message-ID: | CA+Tgmoa3LvZ0MFg1ZKuoJKNPTRERaZv9MroHhwdLN1a684GJyg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Fri, Aug 12, 2016 at 3:22 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Robert Haas <robertmhaas(at)gmail(dot)com> writes:
>> Let's introduce a new variant of SET that only affects the lexical
>> scope of the function to which it is attached, and then do what you
>> said. That would be full of win, because actually I think in nearly
>> every case that's the behavior people actually want.
>
> Hm. I think that sounds a lot easier than it actually is. As an example,
> this would mean that we'd want such a search_path setting to apply during
> parse analysis of a function's body, but not during planning, because it
> should not apply during inlining or const-folding of another function.
> On the other hand, if someone tried to "SET enable_seqscan = off" with
> this new scope (a highly reasonable thing to do), that certainly should
> apply during planning.
Mmm. Maybe this hypothetical new facility should confine itself to
search_path specifically.
> It might be practical to make it work, but it will be ticklish to
> get the scope of the settings to be non-surprising.
Yeah, it's certainly not the sort of thing I'm going to crank out
before breakfast some morning.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2016-08-12 19:35:20 | Re: Surprising behaviour of \set AUTOCOMMIT ON |
Previous Message | Tom Lane | 2016-08-12 19:22:27 | Re: Is there a way around function search_path killing SQL function inlining? |