Re: schema agnostic functions in language sql

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: schema agnostic functions in language sql
Дата
Msg-id 81A0F056-6703-4FD4-96BE-D13485CA1995@gmail.com
обсуждение исходный текст
Ответ на Re: schema agnostic functions in language sql  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general

> On
>>>             regards, tom lane
>> Did my message with a sql and plgpsql versions not come through?
>> I cannot create a plain sql function unless the search_path covers any table mentioned. Not the case when using
plpgsql- no path needed. 
>
> But does the plpgsql segment_calls() run?
>
> On other words does:
>
> select * from segment_calls(segid uuid);
>
> work?
>
>> I'm ok(ish) with that, unless I've missed some detail.
>> rjs
>

Yes the plpgsql form works but of course requires a sufficient search_path
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com



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

Предыдущее
От: RAJAMOHAN
Дата:
Сообщение: Pgpool is crashing when terminating user session
Следующее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Pgpool is crashing when terminating user session