Hi,
very often it is a result of database messages converting problems. They
seem to be related to ASCII to Unicode conversion for languages and codesets
other than English, and this may be related to Python 2 which under pgAdmin4
(default at least on the Windows platforms).
If so, your transaction is broken, and until you invoke ROLLBACK
explicitely, you will get the error 500 because this situation generates
another message which cannot be converted similarly.
You may try to change yout lc_messages (error messages) to English either
for a current session:
set lc_messages to 'English_United States.UTF-8'
or persistently for the whole instance:
1. $datadir\postgresql.conf: lc_messages = 'English.United States.UTF-8'
2. select pg_reload_conf();
It looks that 'English_United States.UTF-8' is Windows-bound and
'en_US.utf8' is for Linux.
I hope it will help.
Kind regards,
Greg
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html