Re: pgAdmin 4 3.0 - bug when browsing on trigger functions

Hi

This was fixed the day after 3.0 was released, and will be in 3.1.

On Tue, Apr 17, 2018 at 3:58 PM, Alan Campbell <
alan(dot)campbell(at)riskpoint(dot)co(dot)uk> wrote:

> Hi,
>
> Description of bug.
>
> The SQL tab shows the following error when clicking on a trigger function:
> “Error retrieving the information - INTERNAL SERVER ERROR”
>
> 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(at)pgadmin(dot)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, in wrap
> return f(*args, **kwargs)
> File "/Applications/pgAdmin 4.app/Contents/Resources/web/
> pgadmin/browser/server_groups/servers/databases/schemas/functions/__init__.py",
> line 1053, in sql
> ) + '(' + 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(at)example(dot)com
>
>
> Kind Regards,
> Alan.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company