pgAdmin4 Bug Report
Hi! I registered an account and signed up for this mailing list just to report this bug, so here is goes: pgAdmin4 v. 1.21 cannot handle Tables who's pk is called uppercase "ID". This sucks a lot because I have to deal with many such tables. Hope this will be fixed, thank you! Further Information: Windows 10 Desktop Mode Steps to reproduce: Create a table with "ID" als primary key. Try to enter data into a row in the grid, click save. This Error appears in the Application: 500 Internal Server Error Internal Server Error The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application. This Error appears in the pgadmin4 log: 2018-02-12 09:43:53,704: ERROR werkzeug: Error on request: Traceback (most recent call last): File "C:\Program Files (x86)\pgAdmin 4\v2\venv\Lib\site-packages\werkzeug\serving.py", line 209, in run_wsgi execute(self.server.app) File "C:\Program Files (x86)\pgAdmin 4\v2\venv\Lib\site-packages\werkzeug\serving.py", line 197, in execute application_iter = app(environ, start_response) File "C:\Program Files (x86)\pgAdmin 4\v2\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\v2\venv\Lib\site-packages\flask\app.py", line 1985, in wsgi_app response = self.handle_exception(e) File "C:\Program Files (x86)\pgAdmin 4\v2\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\v2\venv\Lib\site-packages\flask\app.py", line 1982, in wsgi_app response = self.full_dispatch_request() File "C:\Program Files (x86)\pgAdmin 4\v2\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\v2\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\v2\venv\Lib\site-packages\flask\app.py", line 1612, in full_dispatch_request rv = self.dispatch_request() File "C:\Program Files (x86)\pgAdmin 4\v2\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\v2\venv\Lib\site-packages\flask_login.py", line 792, in decorated_view return func(*args, **kwargs) File "C:\Program Files (x86)\pgAdmin 4\v2\web\pgadmin\tools\sqleditor\__init__.py", line 991, in save default_conn) File "C:\Program Files (x86)\pgAdmin 4\v2\web\pgadmin\tools\sqleditor\command.py", line 647, in save item['select_sql'], res['rows'][0]) File "C:\Program Files (x86)\pgAdmin 4\v2\web\pgadmin\utils\driver\psycopg2\__init__.py", line 1028, in execute_dict self.__internal_blocking_execute(cur, query, params) File "C:\Program Files (x86)\pgAdmin 4\v2\web\pgadmin\utils\driver\psycopg2\__init__.py", line 575, in __internal_blocking_execute cur.execute(query, params) File "C:\Program Files (x86)\pgAdmin 4\v2\web\pgadmin\utils\driver\psycopg2\cursor.py", line 176, in execute return _cursor.execute(self, query, params) KeyError: '"ID"' Kind regards Nicolas Dechamps
Re: pgAdmin4 Bug Report
Hi Nicolas, Logged the bug. You can track through https://redmine.postgresql.org/issues/3105 Thanks, Khushboo On Mon, Feb 12, 2018 at 2:46 PM, Nicolas Dechamps wrote: > Hi! > > I registered an account and signed up for this mailing list just to report > this bug, so here is goes: > > pgAdmin4 v. 1.21 cannot handle Tables who's pk is called uppercase "ID". > This sucks a lot because I have to deal with many such tables. > > Hope this will be fixed, thank you! > > Further Information: > Windows 10 > Desktop Mode > > Steps to reproduce: > > Create a table with "ID" als primary key. > > Try to enter data into a row in the grid, click save. > > This Error appears in the Application: > > > 500 Internal Server Error > Internal Server Error > The server encountered an internal error and was unable to complete > your request. Either the server is overloaded or there is an error in the > application. > > This Error appears in the pgadmin4 log: > > 2018-02-12 09:43:53,704: ERRORwerkzeug:Error on request: > Traceback (most recent call last): > File "C:\Program Files (x86)\pgAdmin > 4\v2\venv\Lib\site-packages\werkzeug\serving.py", > line 209, in run_wsgi > execute(self.server.app) > File "C:\Program Files (x86)\pgAdmin > 4\v2\venv\Lib\site-packages\werkzeug\serving.py", > line 197, in execute > application_iter = app(environ, start_response) > File "C:\Program Files (x86)\pgAdmin > 4\v2\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\v2\venv\Lib\site-packages\flask\app.py", > line 1985, in wsgi_app > response = self.handle_exception(e) > File "C:\Program Files (x86)\pgAdmin > 4\v2\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\v2\venv\Lib\site-packages\flask\app.py", > line 1982, in wsgi_app > response = self.full_dispatch_request() > File "C:\Program Files (x86)\pgAdmin > 4\v2\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\v2\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\v2\venv\Lib\site-packages\flask\app.py", > line 1612, in full_dispatch_request > rv = self.dispatch_request() > File "C:\Program Files (x86)\pgAdmin > 4\v2\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\v2\venv\Lib\site-packages\flask_login.py", > line 792, in decorated_view > return func(*args, **kwargs) > File "C:\Program Files (x86)\pgAdmin > 4\v2\web\pgadmin\tools\sqleditor\__init__.py", > line 991, in save > default_conn) > File "C:\Program Files (x86)\pgAdmin > 4\v2\web\pgadmin\tools\sqleditor\command.py", > line 647, in save > item['select_sql'], res['rows'][0]) > File "C:\Program Files (x86)\pgAdmin > 4\v2\web\pgadmin\utils\driver\psycopg2\__init__.py", > line 1028, in execute_dict > self.__internal_blocking_execute(cur, query, params) > File "C:\Program Files (x86)\pgAdmin > 4\v2\web\pgadmin\utils\driver\psycopg2\__init__.py", > line 575, in __internal_blocking_execute > cur.execute(query, params) > File "C:\Program Files (x86)\pgAdmin > 4\v2\web\pgadmin\utils\driver\psycopg2\cursor.py", > line 176, in execute > return _cursor.execute(self, query, params) > KeyError: '"ID"' > > Kind regards > > Nicolas Dechamps > > >
Conn. loose at some places | TCP keepalive
Hello! At home me and some other colleagues loose the connection after 5 minutes. In other places (office) this not happens. I wrote about this here: https://www.postgresql.org/message-id/CAEcMXhn8Hvu3do5F-k5o3x1nYy3wLHXTNFXU1A2SrADYGo97ww%40mail.gmail.com Yesterday I found a solution-like thing for PGAdmin III here: https://superuser.com/questions/729034/any-way-to-keep-connection-alive-in-pgadmin-without-setting-it-on-the-server In PgAdmin IV I also have this problem. But here I don't find same "service" option to link to my parameters. What I can do here? Do you know hidden service option in PGAdmin IV? The solution is may be an option for "SQL command list after connect" for each servers - with this I could configure TCP keepalive parameters manually. Thank you for your answer! dd
