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'
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 |