Re: [v10] CREATE TEMP FUNCTION/CREATE FUNCTION PG_TEMP.X - Mailing list pgsql-general

From Vincenzo Romano
Subject Re: [v10] CREATE TEMP FUNCTION/CREATE FUNCTION PG_TEMP.X
Date
Msg-id CAHjZ2x7BhSVA+S7fnmPvSbb6HimXCfOdMcFdHG+F27-ToTpfyw@mail.gmail.com
Whole thread Raw
In response to Re: [v10] CREATE TEMP FUNCTION/CREATE FUNCTION PG_TEMP.X  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [v10] CREATE TEMP FUNCTION/CREATE FUNCTION PG_TEMP.X
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: [v10] CREATE TEMP FUNCTION/CREATE FUNCTION PG_TEMP.X
Next
From: Hans Schou
Date:
Subject: Re: Deadlock with one table - PostgreSQL is doing it right