Re: Prevent extension creation in temporary schemas

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Prevent extension creation in temporary schemas
Дата
Msg-id 20190219043803.GS15532@paquier.xyz
обсуждение исходный текст
Ответ на Re: Prevent extension creation in temporary schemas  (Masahiko Sawada <sawada.mshk@gmail.com>)
Список pgsql-hackers
On Mon, Feb 18, 2019 at 08:02:54PM +0900, Masahiko Sawada wrote:
> I'd vote for accepting the extension creation in temporary schemas and
> fixing \dx and \dx+.

Thanks.

> However the error raised by creating extensions
> in temporary schema still looks strange to me. Since we don't search
> functions and operators defined in temporary schemas  (which is stated
> by the doc) unless we use qualified function name we cannot create
> extensions in temporary schema whose functions refer theirs other
> functions. I'd like to fix it or to find a workaround but cannot come
> up with a good idea yet.

Agreed.  Getting a schema mismatch is kind of disappointing, and it
depends on the DDL used in the extension SQL script.  I would suspect
that getting that addressed correctly may add quite some facility, for
little gain.  But I may be wrong, that's only the feeling coming from
a shiver in my back.
--
Michael

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Prevent extension creation in temporary schemas
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Prepared transaction releasing locks before deregistering its GID