Postgres Pro
Downloads
Home   >   mailing lists

Re: Changing a schema's name with function1 calling function2 - Mailing list pgsql-general

From Kirk Wolak
Subject Re: Changing a schema's name with function1 calling function2
Date
Msg-id CACLU5mRBrLfrBg8RcfqefXutus7Vzfg+DG10Ci64hXNN7eqRuw@mail.gmail.com
Whole thread Raw
In response to Re: Changing a schema's name with function1 calling function2  (Christophe Pettus <xof@thebuild.com>)
Responses Re: Changing a schema's name with function1 calling function2  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
On Mon, Dec 25, 2023 at 1:47 PM Christophe Pettus <xof@thebuild.com> wrote:


> On Dec 25, 2023, at 10:44, Adrian Klaver <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 ;

If I understand the issue correctly.

Kirk Out!

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: looking for mariadb-devel to install mysql_fdw_16 in AlmaLinux 9
Next
From: Kirk Wolak
Date:
Subject: Re: Read write performance check