ensure postgres boolean values are handled correctly

also fixed an issue with default value loading of bool columns.

fixes #3489, fixes #4085, fixes #3920
related to #4672