pgAdmin 4 3.0 - bug when browsing on trigger functions - Mailing list pgadmin-support

From Alan Campbell
Subject pgAdmin 4 3.0 - bug when browsing on trigger functions
Date
Msg-id 2BBFEC0F-EABD-4A8A-9875-6573791DECDF@riskpoint.co.uk
Whole thread Raw
Responses Re: pgAdmin 4 3.0 - bug when browsing on trigger functions
List pgadmin-support
Hi,

Description of bug.

The SQL tab shows the following error when clicking on a trigger function: “Error retrieving the information - INTERNAL
SERVERERROR” 

Issue replicated on both macOS (High Sierra 10.13.4) and docker (18.03.0-ce-mac60) versions.

Mac Version:
Version: 3.0
Copyright: Copyright 2013 - 2018, The pgAdmin Development Team
Python Version: 2.7.10 (default, Jul 30 2016, 19:40:32) [GCC 4.2.1 Compatible Apple LLVM 8.0.0 (clang-800.0.34)]
Flask Version: 0.12.2
Application Mode: Desktop
Current User: pgadmin4@pgadmin.org

Output from log

 2018-04-17 11:47:59,885: ERROR    werkzeug:    Error on request:
Traceback (most recent call last):
  File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/werkzeug/serving.py", line 270, in
run_wsgi
    execute(self.server.app)
  File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/werkzeug/serving.py", line 258, in
execute
    application_iter = app(environ, start_response)
  File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1997, in
__call__
    return self.wsgi_app(environ, start_response)
  File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1985, in
wsgi_app
    response = self.handle_exception(e)
  File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1540, in
handle_exception
    reraise(exc_type, exc_value, tb)
  File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1982, in
wsgi_app
    response = self.full_dispatch_request()
  File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1614, in
full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1517, in
handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1612, in
full_dispatch_request
    rv = self.dispatch_request()
  File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1598, in
dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/views.py", line 84, in view
    return self.dispatch_request(*args, **kwargs)
  File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/browser/utils.py", line 254, in dispatch_request
    return method(*args, **kwargs)
  File "/Applications/pgAdmin
4.app/Contents/Resources/web/pgadmin/browser/server_groups/servers/databases/schemas/functions/__init__.py",line 345,
inwrap 
    return f(*args, **kwargs)
  File "/Applications/pgAdmin
4.app/Contents/Resources/web/pgadmin/browser/server_groups/servers/databases/schemas/functions/__init__.py",line 1053,
insql 
    ) + '(' + res['rows'][0]['func_args'] + ')'
KeyError: ‘nspname'


Docker version:
Version: 3.0
Copyright: Copyright 2013 - 2018, The pgAdmin Development Team
Python Version: 3.6.5 (default, Mar 31 2018, 01:52:14) [GCC 6.4.0]
Flask Version: 0.12.2
Application Mode: Server
Current User: pgadmin@example.com


Kind Regards,
Alan.
Attachment

pgadmin-support by date:

Previous
From: Sandeep Thakkar
Date:
Subject: Re: pgadmin 4 v3.0 installation
Next
From: Dave Page
Date:
Subject: Re: pgAdmin 4 3.0 - bug when browsing on trigger functions