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

From: Kirk Wolak <wolakk(at)gmail(dot)com>
To: Christophe Pettus <xof(at)thebuild(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Wilma Wantren <wilma(dot)wantren(at)eclipso(dot)de>, "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Changing a schema's name with function1 calling function2
Date: 2023-12-27 06:41:39
Message-ID: CACLU5mRBrLfrBg8RcfqefXutus7Vzfg+DG10Ci64hXNN7eqRuw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Dec 25, 2023 at 1:47 PM Christophe Pettus <xof(at)thebuild(dot)com> wrote:

>
>
> > On Dec 25, 2023, at 10:44, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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 ;

If I understand the issue correctly.

Kirk Out!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kirk Wolak 2023-12-27 07:29:59 Re: Read write performance check
Previous Message Adrian Klaver 2023-12-27 05:28:49 Re: looking for mariadb-devel to install mysql_fdw_16 in AlmaLinux 9