Postgresql: Unable to add device

[jpvrenen]

When using postgresql, unable to add a device:

The sql query produces an error when trying to compare int with text. device_port = int pool.device_port = text

sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedFunction) operator does not exist: text = integer LINE 3: ...) OR pool.device_port != '' AND (pool.device_port = 22 AND p... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.

No issue is observed adding a device when using the sqlite DB.

[jpvrenen]

Since sqlite, mysql and mariadb are working without having this issue we switched to mariadb.