Hi Fontana, Please do not log a new bug, the bug is already logged here - https://redmine.postgresql.org/issues/4123. We'll look into this.
On Wed, Aug 5, 2020 at 9:53 AM Aditya Toshniwal < aditya.toshni...@enterprisedb.com> wrote: > Hi Fontana, > > It may be possible that you've set the search_path to something other than > public. And so, the function pldbg_get_proxy_info is not found. > Please report the bug here - > https://redmine.postgresql.org/projects/pgadmin4/issues/new. I think the > function pldbg_get_proxy_info should be called with the apt. schema > qualified name. > > On Wed, Aug 5, 2020 at 3:41 AM Fontana Daniel C (Desartec S.R.L.) < > desartec...@gmail.com> wrote: > >> Hello: >> After enabling en file postgresql.conf shared_preload_libraries = '$ >> libdir/plugin_debugger.dll' >> and installing the pldbgapi extension. >> I try to debug a created function and pgadmin4 displays the following >> error. >> >> Local variable 'debugger_version' referenced before assignment. >> >> This variable is not in my function, what is the error. >> >> PostgreSQL 12.2, compiled by Visual C++ build 1914, 64-bit (Windows 2019) >> PgAdmin 4.23 >> >> The pgadmin4 log says: >> >> --------------------------------- >> 2020-08-04 18:11:33,826: ERROR flask.app: Failed to execute query >> (execute_scalar) for the server #2 - CONN:9214613 (Query-id: 1047347): >> Error Message:ERROR: no existe la función pldbg_get_proxy_info() LINE >> 1: SELECT proxyapiver FROM pldbg_get_proxy_info(); >> ^ >> HINT: Ninguna función coincide en el nombre y tipos de argumentos. >> Puede ser necesario agregar conversión explícita de tipos. >> >> 2020-08-04 18:11:33,827: ERROR flask.app: local variable >> 'debugger_version' referenced before assignment >> Traceback (most recent call last): >> File "C:/Program Files/PostgreSQL/12/pgAdmin 4/venv/Lib/site- >> packages\flask\app.py", line 1813, in full_dispatch_request >> rv = self.dispatch_request() >> File "C:/Program Files/PostgreSQL/12/pgAdmin 4/venv/Lib/site- >> packages\flask\app.py", line 1799, in dispatch_request >> return self.view_functions[rule.endpoint](**req.view_args) >> File "C:/Program Files/PostgreSQL/12/pgAdmin 4/venv/Lib/site- >> packages\flask_login\utils.py", line 261, in decorated_view >> return func(*args, **kwargs) >> File "C:\Program Files\PostgreSQL\12\pgAdmin >> 4\web\pgadmin\tools\debugger\__init__.py", line 747, in initialize_target >> current_app.logger.debug("Debugger version is: %d", debugger_version) >> UnboundLocalError: local variable 'debugger_version' referenced before >> assignment >> --------------------------------- >> >> I found the problem. If the scheme is "pulic" it works correctly, with >> another scheme the error occurs. >> Why can't I use another scheme? >> Note that SELECT proxyapiver FROM pldbg_get_proxy_info (); >> It is not placing the schema correctly where I am working, in my case >> "dba" >> And now what do I do? >> >> >> >> >> > > -- > Thanks, > Aditya Toshniwal > pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com* > <http://edbpostgres.com> > "Don't Complain about Heat, Plant a TREE" > -- Thanks, Aditya Toshniwal pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com* <http://edbpostgres.com> "Don't Complain about Heat, Plant a TREE"
