pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17750: Plugin_debugger not work when have pg_hint_plan on shared_preload_libraries
2+ messages / 2 participants
[nested] [flat]
* BUG #17750: Plugin_debugger not work when have pg_hint_plan on shared_preload_libraries
@ 2023-01-12 15:31 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2023-01-12 15:31 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: junior@rassystem.com.br
The following bug has been logged on the website:
Bug reference: 17750
Logged by: Paulo La Luna Junior
Email address: junior@rassystem.com.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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #17750: Plugin_debugger not work when have pg_hint_plan on shared_preload_libraries
@ 2023-01-12 16:19 Pavel Stehule <pavel.stehule@gmail.com>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: Pavel Stehule @ 2023-01-12 16:19 UTC (permalink / raw)
To: junior@rassystem.com.br; pgsql-bugs@lists.postgresql.org
Hi
čt 12. 1. 2023 v 17:01 odesílatel PG Bug reporting form <
noreply@postgresql.org> napsal:
> The following bug has been logged on the website:
>
> Bug reference: 17750
> Logged by: Paulo La Luna Junior
> Email address: junior@rassystem.com.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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2023-01-12 16:19 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-01-12 15:31 BUG #17750: Plugin_debugger not work when have pg_hint_plan on shared_preload_libraries PG Bug reporting form <noreply@postgresql.org>
2023-01-12 16:19 ` Pavel Stehule <pavel.stehule@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox