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 <n...@moonsilence.de>
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:
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
> <title>500 Internal Server Error</title>
> <h1>Internal Server Error</h1>
> <p>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.</p>
>
> 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
>
>
>

Reply via email to