| From: | Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com> |
|---|---|
| To: | Nicolas Dechamps <nick(at)moonsilence(dot)de> |
| Cc: | pgadmin-support(at)lists(dot)postgresql(dot)org |
| Subject: | Re: pgAdmin4 Bug Report |
| Date: | 2018-02-12 10:12:49 |
| Message-ID: | CAFOhELfXEiGNR=kiAM4BK2x97zsj=Y7jKaFqYfHfRXhyVyWg9g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
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 <nick(at)moonsilence(dot)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
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Durumdara | 2018-02-13 07:56:59 | Conn. loose at some places | TCP keepalive |
| Previous Message | Nicolas Dechamps | 2018-02-12 09:16:44 | pgAdmin4 Bug Report |