From: | Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com> |
---|---|
To: | Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com> |
Cc: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | Re: pgAdmin debugger failure when search_path set |
Date: | 2020-08-11 06:43:24 |
Message-ID: | CANxoLDc9mzVMRBVpVk0i4qtBMM+EDOk7Js8RpDV8mj3R9mHuwQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
Hi Aditya
On Thu, Aug 6, 2020 at 4:48 PM Aditya Toshniwal <
aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
> Hi Dave/Team,
>
> I've been working on an issue to make debugger work no matter what the
> search patch is set. I've managed to call the appropriate functions from
> pgAdmin using a schema qualified name with no issues. However, the internal
> calls in the function don't look schema qualified.
> For instance,
> I have two schemas "public" where the debugger is installed and "other"
> where my user defined function is. I set the search_path to "other" on the
> database. Calling plpgsql_oid_debug directly fails because of the search
> path set, but I can call the debugger functions with
> public.plpgsql_oid_debug, but it fails with:
> ERROR: function pldbg_oid_debug(oid) does not exist LINE 1: SELECT
> pldbg_oid_debug($1) ^ HINT: No function matches the given name and argument
> types. You might need to add explicit type casts. QUERY: SELECT
> pldbg_oid_debug($1) CONTEXT: SQL function "plpgsql_oid_debug" during
> inlining
>
> How to approach this ? It is inconvenient for users to remove their
> search_path to make debugger work.
>
To solve the above problem I would suggest, get the existing search
path and append *'public' *in that and set it only for the Debugger session
and reset back when a debugger is closed.
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com*
> <http://edbpostgres.com>
> "Don't Complain about Heat, Plant a TREE"
>
--
*Thanks & Regards*
*Akshay Joshi*
*pgAdmin Hacker | Sr. Software Architect*
*EDB Postgres <http://edbpostgres.com>*
*Mobile: +91 976-788-8246*
From | Date | Subject | |
---|---|---|---|
Next Message | Aditya Toshniwal | 2020-08-11 06:47:15 | Re: pgAdmin debugger failure when search_path set |
Previous Message | Aditya Toshniwal | 2020-08-11 06:11:34 | [pgAdmin][SonarQube] Reduce cognitive complexity |