From: | Michael Paquier <michael(at)paquier(dot)xyz> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: pgsql: Restrict the use of temporary namespace in two-phase transaction |
Date: | 2019-01-19 00:08:27 |
Message-ID: | 20190119000827.GB2660@paquier.xyz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers pgsql-hackers |
On Fri, Jan 18, 2019 at 03:34:30PM -0500, Tom Lane wrote:
> Seems hard to avoid. We could conceivably make it return "pg_temp"
> for the temp schema instead of the schema's actual name, but it's
> not very hard to think of ways whereby that would make use of the
> result fail in contexts where it previously worked.
CREATE EXTENSION is one such case. It would not work if referring to
the synonym pg_temp, but it can work if using directly the temporary
namespace of the session. So I feel that changing such things is
prone to break more things than to actually fix things.
> Another idea is to force creation of the temp namespace as soon as
> we see that search_path references it. I'm not very sure exactly
> where would be a convenient place to make that happen, though.
> There are paths whereby the GUC's value will change outside a
> transaction, so we couldn't tie it directly to the GUC update.
This is documented at the top of namespace.c: "initial GUC processing
of search_path happens outside a transaction".
--
Michael
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2019-01-19 01:12:00 | Re: pgsql: Restrict the use of temporary namespace in two-phase transaction |
Previous Message | Michael Paquier | 2019-01-19 00:04:20 | Re: pgsql: Remove references to Majordomo |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-01-19 00:24:18 | Re: Fixing findDependentObjects()'s dependency on scan order (regressions in DROP diagnostic messages) |
Previous Message | Peter Geoghegan | 2019-01-19 00:06:58 | Re: Fixing findDependentObjects()'s dependency on scan order (regressions in DROP diagnostic messages) |