The following column:

gets created by Liquibase in PostgreSQL 9.5 as double precision:

which will causes error when used: (this is just an example, though)

PostgreSQL manual (https://www.postgresql.org/docs/9.5/static/datatype-numeric.html) explicitly states that real is a 4 bytes variable precision with 6 decimal digits precision, i.e. same as float(24).

Related to:
Stackoverflow: http://stackoverflow.com/questions/16890723/list-all-liquibase-sql-types#comment63532747_28626825

Workaround: Use float(24)