BUG #15210: Internal Server Error When Attempting to Look at Trigger Functions

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: diana(dot)petty(at)csra(dot)com
Subject: BUG #15210: Internal Server Error When Attempting to Look at Trigger Functions
Date: 2018-05-25 18:23:44
Message-ID: 152727262492.26748.13676661884987149404@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 15210
Logged by: Diana Petty
Email address: diana(dot)petty(at)csra(dot)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'

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2018-05-25 18:28:56 Re: BUG #15210: Internal Server Error When Attempting to Look at Trigger Functions
Previous Message Rick Gabriel 2018-05-25 17:48:45 Re: BUG #15208: COALESCE with CTE returns NULL