BUG #15210: Internal Server Error When Attempting to Look at TriggerFunctions - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #15210: Internal Server Error When Attempting to Look at TriggerFunctions
Date
Msg-id 152727262492.26748.13676661884987149404@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #15210: Internal Server Error When Attempting to Look atTrigger Functions  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15210
Logged by:          Diana Petty
Email address:      diana.petty@csra.com
PostgreSQL version: 10.4
Operating system:   Server=Redhat, pgAdmin = Mac OS High Sierra
Description:

I log into pgAdmin pointing at either our 10.4 server or our 9.5 server - I
get the same error in both cases.  I open the schema, click on trigger
functions, and click on one to show in the sql panel.  Then I get the
internal server error.  It doesn't matter which schema or which trigger
function.  Other objects display appropriately. Here is the contents of the
log:

2018-05-25 14:07:32,657: 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'


pgsql-bugs by date:

Previous
From: Rick Gabriel
Date:
Subject: Re: BUG #15208: COALESCE with CTE returns NULL
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #15210: Internal Server Error When Attempting to Look atTrigger Functions