Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 12/26/23 22:41, Kirk Wolak wrote:
On Mon, Dec 25, 2023 at 1:47 PM Christophe Pettus <xof@xxxxxxxxxxxx <mailto:xof@xxxxxxxxxxxx>> wrote:



     > On Dec 25, 2023, at 10:44, Adrian Klaver
    <adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> 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@xxxxxxxxxxx






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux