From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | junior(at)rassystem(dot)com(dot)br, pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #17750: Plugin_debugger not work when have pg_hint_plan on shared_preload_libraries |
Date: | 2023-01-12 16:19:27 |
Message-ID: | CAFj8pRC33Pfu4fGw0y5LCMbh5-jYBiBV5U3m3FWteisgbCdtAA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi
čt 12. 1. 2023 v 17:01 odesílatel PG Bug reporting form <
noreply(at)postgresql(dot)org> napsal:
> The following bug has been logged on the website:
>
> Bug reference: 17750
> Logged by: Paulo La Luna Junior
> Email address: junior(at)rassystem(dot)com(dot)br
> PostgreSQL version: 12.13
> Operating system: Docker from image postgres:12.13
> Description:
>
> Hi,
>
> I did several tests and the Debbuger Plugin does not work when the
> shared_preload_libraries has "plugin_debugger,pg_hint_plan".
> When shared_preload_libraries has only "plugin_debugger" or with other
> libraries like "auto_explain,plugin_debugger,pg_stat_statements,pg_repack",
> it's work.
>
> I can create function and create extension without any error. But when I
> use
> Debug from PGAdmin or Dbeaver it doesn't return the debug result.
>
The plugin debugger uses dbg API, pg_hint_plan uses dbg API too.
Unfortunately this API is not designed to be used by two active extensions
in one time.
I found a workaround in plpgsql_check, but it requires modification in
extensions. You should report this issue to their authors.
https://github.com/ossc-db/pg_hint_plan/issues
https://github.com/EnterpriseDB/pldebugger/issues
And I see you did it.
The fix is not on the PostgreSQL side.
Regards
Pavel
From | Date | Subject | |
---|---|---|---|
Next Message | John Naylor | 2023-01-13 01:59:22 | Re: Facing issue while installing postgresql |
Previous Message | niharaj g | 2023-01-12 16:18:36 | Facing issue while installing postgresql |