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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: [v10] CREATE TEMP FUNCTION/CREATE FUNCTION PG_TEMP.X
Date: 2017-12-21 16:56:14
Message-ID: 2830.1513875374@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it> writes:
> 2017-12-21 17:52 GMT+01:00 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vincenzo Romano 2017-12-21 17:07:38 Re: [v10] CREATE TEMP FUNCTION/CREATE FUNCTION PG_TEMP.X
Previous Message Vincenzo Romano 2017-12-21 16:53:55 Re: [v10] CREATE TEMP FUNCTION/CREATE FUNCTION PG_TEMP.X