2017-12-22 0:50 GMT+01:00 Melvin Davidson :
>
>
>
> On Thu, Dec 21, 2017 at 12:07 PM, Vincenzo Romano
> wrote:
>>
>> 2017-12-21 17:56 GMT+01:00 Tom Lane :
>> > Vincenzo Romano writes:
>> >> 2017-12-21 17:52 GMT+01:00 Tom Lane :
>> >>> You have to schema-qualify the temp function name when callin
On Thu, Dec 21, 2017 at 12:07 PM, Vincenzo Romano <
vincenzo.rom...@notorand.it> wrote:
> 2017-12-21 17:56 GMT+01:00 Tom Lane :
> > Vincenzo Romano writes:
> >> 2017-12-21 17:52 GMT+01:00 Tom Lane :
> >>> You have to schema-qualify the temp function name when calling it, too.
> >
> >> So search_p
2017-12-21 17:56 GMT+01:00 Tom Lane :
> Vincenzo Romano writes:
>> 2017-12-21 17:52 GMT+01:00 Tom Lane :
>>> 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/operat
Vincenzo Romano writes:
> 2017-12-21 17:52 GMT+01:00 Tom Lane :
>> 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 ju
2017-12-21 17:52 GMT+01:00 Tom Lane :
> Vincenzo Romano writes:
>> It seems I cannot use a temporary function.
>
> You have to schema-qualify the temp function name when calling it, too.
>
> regards, tom lane
Hi.
So search_path is not used with functions?
--
Vincenzo Rom
Vincenzo Romano writes:
> It seems I cannot use a temporary function.
You have to schema-qualify the temp function name when calling it, too.
regards, tom lane
Hi all.
It seems I cannot use a temporary function.
I know there's no "CREATE TEMP FUNCTION".
But while I can do
tmp2=# CREATE FUNCTION pg_temp.x( OUT b BOOL )
language PLPGSQL
AS $L0$
BEGIN
b := TRUE;
END;
$L0$;
SET search_path TO pg_temp,"$user", public;
the following fails:
tmp2=# SELECT *
