Postgres Pro
Downloads
Home   >   mailing lists

Re: plpgsql_check_function issue after upgrade - Mailing list pgsql-general

From shashidhar Reddy
Subject Re: plpgsql_check_function issue after upgrade
Date
Msg-id CAH=zU4t0SsyEzoOS_TqAYKRByR2G4-msmOUxHGWoEVdhvq+dRw@mail.gmail.com
Whole thread Raw
In response to Re: plpgsql_check_function issue after upgrade  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Tree view


On Tue, 6 Dec, 2022, 4:17 pm Pavel Stehule, <pavel.stehule@gmail.com> 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.


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

pgsql-general by date:

Previous
From: Mateusz Henicz
Date:
Subject: Re: Monitoring-only role
Next
From: Michael Loftis
Date:
Subject: Re: postgres large database backup