Re: Changing a schema's name with function1 calling function2

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Changing a schema's name with function1 calling function2
Дата
Msg-id c2954d6e-a739-431e-829a-02919d58b48b@aklaver.com
обсуждение исходный текст
Ответ на Re: Changing a schema's name with function1 calling function2  (Kirk Wolak <wolakk@gmail.com>)
Ответы Re: Re: Changing a schema's name with function1 calling function2
Список pgsql-general
On 12/26/23 22:41, Kirk Wolak wrote:
> On Mon, Dec 25, 2023 at 1:47 PM Christophe Pettus <xof@thebuild.com 
> <mailto:xof@thebuild.com>> wrote:
> 
> 
> 
>      > On Dec 25, 2023, at 10:44, Adrian Klaver
>     <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:
>      > Functions with same name in different schemas would need to be
>     dealt with.
> 
>     I think that's the primary use-case (at least, it would be for me),
>     and I don't see a convenient way of doing that.  Even a "get OID of
>     current function" function would be useful here.
> 
> And Pavel Already Created it:
> GET DIAGNOSTIC PID = PG_ROUTINE_OID ;

To be clear the above is for Postgres 16+ and for the plpgsql language only.

> 
> If I understand the issue correctly.
> 
> Kirk Out!

-- 
Adrian Klaver
adrian.klaver@aklaver.com




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

Предыдущее
От: Kaushik Iska
Дата:
Сообщение: Re: Intermittent Issue with WAL Segment Removal in Logical Replication
Следующее
От: Clemens Eisserer
Дата:
Сообщение: Re: Query crash with 15.5 on debian bookworm/armv8