Re: plpgsql_check_function issue after upgrade

[shashidhar Reddy <shashidharreddy001@xxxxxxxxx>]

On Tue, 6 Dec, 2022, 4:17 pm Pavel Stehule, <pavel.stehule@xxxxxxxxx> wrote:

Hi

for record - the problem was probably in using plpgsql_check together with PL debugger (plugin_debugger). Both extensions use the PLpgSQL DBG API, but this API is not designed to be used by more extensions. plpgsql_check has implemented some workaround, but it should be loaded last if this workaround should work. Older versions of plpgsq_check (without profiler) didn't use DBG API.

https://github.com/okbob/plpgsql_check#using-with-plugin_debugger

I am loading the plpgsql_chect last after loading other extensions.

Looks like it is working for now, but need more time to check on it.

Regards

Pavel