#483 PostgreSQL boolean type update fails

[Stanislav Kocanda]

Updating an existing row fails with

ERROR: invalid input syntax for type boolean: ""

in case there are fields of the boolean type set to false.

The generated query tries to assign '' to the field, although it should be one of the values listed here: http://www.postgresql.org/docs/9.0/static/datatype-boolean.html

PostgreSQL 9.4.5

[Jakub Vrána]

I believe this is fixed by https://github.com/vrana/adminer/pull/183.

[Finbar Barton Maunsell]

I'm having the same problem with the latest version of Adminer. Not sure how to fix.
Using Postgresql version 9.6.2