This bug was found just after we release pgAdmin4 v3.0 but we have fixed it now and it should resolve the issue with next release. Ref: https://redmine.postgresql.org/issues/3179
-- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company On Thu, May 17, 2018 at 7:26 PM, McDonaldR <mcdona...@angus.gov.uk> wrote: > Hi List > > > > I’ve comes across an error when trying to access my triggers through > pgAdmin 4 v3.0. Maybe you can point me in the right direction for a > solution? Expanding the tree down through database > schemas > schema > > trigger functions > trigger returns: > > > > Error retrieving the information – INTERNAL SERVER ERROR > > Click for details > > > > <click> > > > > > > Accessing functions, materialised views, sequences, tables and views works > fine. Everything works as expected in pgAdmin3 1.22.2. > > > > The pgAdmin4.log has the following in it: > > > > 2018-05-17 14:28:06,539: ERROR pgadmin: Exception when > checking for update > > Traceback (most recent call last): > > File "C:\Program Files (x86)\pgAdmin 4\v3\web\pgadmin\browser\__init__.py", > line 508, in index > > response = urlreq.urlopen(url, data, 5) > > File "C:/Program Files (x86)/pgAdmin 4/v3/venv\lib\urllib2.py", line > 154, in urlopen > > return opener.open(url, data, timeout) > > File "C:/Program Files (x86)/pgAdmin 4/v3/venv\lib\urllib2.py", line > 429, in open > > response = self._open(req, data) > > File "C:/Program Files (x86)/pgAdmin 4/v3/venv\lib\urllib2.py", line > 447, in _open > > '_open', req) > > File "C:/Program Files (x86)/pgAdmin 4/v3/venv\lib\urllib2.py", line > 407, in _call_chain > > result = func(*args) > > File "C:/Program Files (x86)/pgAdmin 4/v3/venv\lib\urllib2.py", line > 1241, in https_open > > context=self._context) > > File "C:/Program Files (x86)/pgAdmin 4/v3/venv\lib\urllib2.py", line > 1198, in do_open > > raise URLError(err) > > URLError: <urlopen error Tunnel connection failed: 407 Proxy > Authentication Required> > > 2018-05-17 14:28:45,897: ERROR werkzeug: Error on request: > > Traceback (most recent call last): > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\werkzeug\serving.py", > line 209, in run_wsgi > > execute(self.server.app) > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\werkzeug\serving.py", > line 197, in execute > > application_iter = app(environ, start_response) > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\flask\app.py", > line 1997, in __call__ > > return self.wsgi_app(environ, start_response) > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\flask\app.py", > line 1985, in wsgi_app > > response = self.handle_exception(e) > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\flask\app.py", > line 1540, in handle_exception > > reraise(exc_type, exc_value, tb) > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\flask\app.py", > line 1982, in wsgi_app > > response = self.full_dispatch_request() > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\flask\app.py", > line 1614, in full_dispatch_request > > rv = self.handle_user_exception(e) > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\flask\app.py", > line 1517, in handle_user_exception > > reraise(exc_type, exc_value, tb) > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\flask\app.py", > line 1612, in full_dispatch_request > > rv = self.dispatch_request() > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\flask\app.py", > line 1598, in dispatch_request > > return self.view_functions[rule.endpoint](**req.view_args) > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\flask\views.py", > line 84, in view > > return self.dispatch_request(*args, **kwargs) > > File "C:\Program Files (x86)\pgAdmin 4\v3\web\pgadmin\browser\utils.py", > line 254, in dispatch_request > > return method(*args, **kwargs) > > File "C:\Program Files (x86)\pgAdmin 4\v3\web\pgadmin\browser\ > server_groups\servers\databases\schemas\functions\__init__.py", line 345, > in wrap > > return f(*args, **kwargs) > > File "C:\Program Files (x86)\pgAdmin 4\v3\web\pgadmin\browser\ > server_groups\servers\databases\schemas\functions\__init__.py", line > 1053, in sql > > ) + '(' + res['rows'][0]['func_args'] + ')' > > KeyError: 'nspname' > > 2018-05-17 14:31:10,102: ERROR werkzeug: Error on request: > > Traceback (most recent call last): > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\werkzeug\serving.py", > line 209, in run_wsgi > > execute(self.server.app) > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\werkzeug\serving.py", > line 197, in execute > > application_iter = app(environ, start_response) > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\flask\app.py", > line 1997, in __call__ > > return self.wsgi_app(environ, start_response) > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\flask\app.py", > line 1985, in wsgi_app > > response = self.handle_exception(e) > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\flask\app.py", > line 1540, in handle_exception > > reraise(exc_type, exc_value, tb) > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\flask\app.py", > line 1982, in wsgi_app > > response = self.full_dispatch_request() > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\flask\app.py", > line 1614, in full_dispatch_request > > rv = self.handle_user_exception(e) > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\flask\app.py", > line 1517, in handle_user_exception > > reraise(exc_type, exc_value, tb) > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\flask\app.py", > line 1612, in full_dispatch_request > > rv = self.dispatch_request() > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\flask\app.py", > line 1598, in dispatch_request > > return self.view_functions[rule.endpoint](**req.view_args) > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\flask\views.py", > line 84, in view > > return self.dispatch_request(*args, **kwargs) > > File "C:\Program Files (x86)\pgAdmin 4\v3\web\pgadmin\browser\utils.py", > line 254, in dispatch_request > > return method(*args, **kwargs) > > File "C:\Program Files (x86)\pgAdmin 4\v3\web\pgadmin\browser\ > server_groups\servers\databases\schemas\functions\__init__.py", line 345, > in wrap > > return f(*args, **kwargs) > > File "C:\Program Files (x86)\pgAdmin 4\v3\web\pgadmin\browser\ > server_groups\servers\databases\schemas\functions\__init__.py", line > 1053, in sql > > ) + '(' + res['rows'][0]['func_args'] + ')' > > KeyError: 'nspname' > > 2018-05-17 14:33:43,618: ERROR werkzeug: Error on request: > > Traceback (most recent call last): > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\werkzeug\serving.py", > line 209, in run_wsgi > > execute(self.server.app) > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\werkzeug\serving.py", > line 197, in execute > > application_iter = app(environ, start_response) > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\flask\app.py", > line 1997, in __call__ > > return self.wsgi_app(environ, start_response) > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\flask\app.py", > line 1985, in wsgi_app > > response = self.handle_exception(e) > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\flask\app.py", > line 1540, in handle_exception > > reraise(exc_type, exc_value, tb) > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\flask\app.py", > line 1982, in wsgi_app > > response = self.full_dispatch_request() > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\flask\app.py", > line 1614, in full_dispatch_request > > rv = self.handle_user_exception(e) > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\flask\app.py", > line 1517, in handle_user_exception > > reraise(exc_type, exc_value, tb) > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\flask\app.py", > line 1612, in full_dispatch_request > > rv = self.dispatch_request() > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\flask\app.py", > line 1598, in dispatch_request > > return self.view_functions[rule.endpoint](**req.view_args) > > File "C:\Program Files (x86)\pgAdmin > 4\v3\venv\Lib\site-packages\flask\views.py", > line 84, in view > > return self.dispatch_request(*args, **kwargs) > > File "C:\Program Files (x86)\pgAdmin 4\v3\web\pgadmin\browser\utils.py", > line 254, in dispatch_request > > return method(*args, **kwargs) > > File "C:\Program Files (x86)\pgAdmin 4\v3\web\pgadmin\browser\ > server_groups\servers\databases\schemas\functions\__init__.py", line 345, > in wrap > > return f(*args, **kwargs) > > File "C:\Program Files (x86)\pgAdmin 4\v3\web\pgadmin\browser\ > server_groups\servers\databases\schemas\functions\__init__.py", line > 1053, in sql > > ) + '(' + res['rows'][0]['func_args'] + ')' > > KeyError: 'nspname' > > > > > > *pgAdmin4 Version* > > 3.0 > > *Copyright* > > Copyright 2013 - 2018, The pgAdmin Development Team > > *Python Version* > > 2.7.13 (v2.7.13:a06454b1afa1, Dec 17 2016, 20:42:59) [MSC v.1500 32 bit > (Intel)] > > *Flask Version* > > 0.12.2 > > *Application Mode* > > Desktop > > *Current User* > > pgadm...@pgadmin.org > > > > Postgresql 9.6.9 64bit > > PostGIS 2.4.4 > > > > Client Windows 7 64bit > > > > Server Windows 2008 R2 > > > > > > *Ross McDonald | *GIS Data Coordinator | Angus Council, People, IT | > Angus House, Orchardbank Business Park, Sylvie Way, Forfar DD8 1AT* | t: > 01307 476419* > > > > > This message is strictly confidential. If you have received this in error, > please inform the sender and remove it from your system. If received in > error you may not copy, print, forward or use it or any attachment in any > way. This message is not capable of creating a legal contract or a binding > representation and does not represent the views of Angus Council. Emails > may be monitored for security and network management reasons. Messages > containing inappropriate content may be intercepted. Angus Council does not > accept any liability for any harm that may be caused to the recipient > system or data on it by this message or any attachment. >
