Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: [v10] CREATE TEMP FUNCTION/CREATE FUNCTION PG_TEMP.X
Date
Msg-id 2830.1513875374@sss.pgh.pa.us
Whole thread Raw
In response to Re: [v10] CREATE TEMP FUNCTION/CREATE FUNCTION PG_TEMP.X  (Vincenzo Romano <vincenzo.romano@notorand.it>)
Responses Re: [v10] CREATE TEMP FUNCTION/CREATE FUNCTION PG_TEMP.X
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Vincenzo Romano
Date:
Subject: Re: [v10] CREATE TEMP FUNCTION/CREATE FUNCTION PG_TEMP.X
Next
From: Vincenzo Romano
Date:
Subject: Re: [v10] CREATE TEMP FUNCTION/CREATE FUNCTION PG_TEMP.X