pgAdmin4 Bug Report

Поиск
Список
Период
Сортировка
От Nicolas Dechamps
Тема pgAdmin4 Bug Report
Дата
Msg-id 3362d421-a35f-7501-a907-b867b1490d83@moonsilence.de
обсуждение исходный текст
Ответы Re: pgAdmin4 Bug Report  (Khushboo Vashi <khushboo.vashi@enterprisedb.com>)
Список pgadmin-support
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



В списке pgadmin-support по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: pgAdmin 4 in an unprivileged lxc container
Следующее
От: Khushboo Vashi
Дата:
Сообщение: Re: pgAdmin4 Bug Report