Re: Error on accessing SQL tab for triggers

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 <McDonaldR(at)angus(dot)gov(dot)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*
>
> pgadmin4(at)pgadmin(dot)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.
>