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>

[cid:image001.png@01D3EDEC.BEB787C0]

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.

Reply via email to