Re: pg_execute_from_file review

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_execute_from_file review
Дата
Msg-id 29147.1291758613@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_execute_from_file review  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
Ответы Re: pg_execute_from_file review  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
Список pgsql-hackers
Dimitri Fontaine <dimitri@2ndQuadrant.fr> writes:
> Tom Lane <tgl@sss.pgh.pa.us> writes:
>> Anyway, in a less blue-sky vein: we could fix some of these problems by
>> having an explicit relocatable-or-not property for extensions.  If it is
>> relocatable, it's required to keep all its owned objects in the target
>> schema, and ALTER EXTENSION .. SET SCHEMA is allowed; else not.  This
>> does nothing for the fix-the-search_path-property problem, though.

> The search_path is the complex (as in AI complete) part of it, but given
> your idea here, we could make it so that only the non-relocatable
> extensions benefit from the @extschema@ placeholder.

Er ... what good is that?  A non-relocatable extension doesn't *need*
any such substitution, because it knows perfectly well what schema it's
putting its stuff into.  Only the relocatable case has use for it.  So
you might as well drop the substitution mechanism entirely.
        regards, tom lane


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

Предыдущее
От: "David E. Wheeler"
Дата:
Сообщение: Re: pg_execute_from_file review
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: pl/python improvements