Re: [v10] CREATE TEMP FUNCTION/CREATE FUNCTION PG_TEMP.X

Поиск
Список
Период
Сортировка
От Vincenzo Romano
Тема Re: [v10] CREATE TEMP FUNCTION/CREATE FUNCTION PG_TEMP.X
Дата
Msg-id CAHjZ2x7BhSVA+S7fnmPvSbb6HimXCfOdMcFdHG+F27-ToTpfyw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [v10] CREATE TEMP FUNCTION/CREATE FUNCTION PG_TEMP.X  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [v10] CREATE TEMP FUNCTION/CREATE FUNCTION PG_TEMP.X  (Melvin Davidson <melvin6925@gmail.com>)
Список pgsql-general
2017-12-21 17:56 GMT+01:00 Tom Lane <tgl@sss.pgh.pa.us>:
> Vincenzo Romano <vincenzo.romano@notorand.it> writes:
>> 2017-12-21 17:52 GMT+01:00 Tom Lane <tgl@sss.pgh.pa.us>:
>>> You have to schema-qualify the temp function name when calling it, too.
>
>> So search_path is not used with functions?
>
> pg_temp is explicitly ignored when searching for functions/operators.
> Otherwise, installing a trojan horse is just too easy.
>
>                         regards, tom lane

I'm not sure whether this decision actually makes PG more scure.
But, anyway, thanks for the insight: I've just found the
documentations for this.

-- 
Vincenzo Romano - NotOrAnd.IT
Information Technologies
--
NON QVIETIS MARIBVS NAVTA PERITVS


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [v10] CREATE TEMP FUNCTION/CREATE FUNCTION PG_TEMP.X
Следующее
От: Hans Schou
Дата:
Сообщение: Re: Deadlock with one table - PostgreSQL is doing it right