|
Added "Geographical" behaviour to an entity:
Using the standard Symfony-generated admin manager, when trying to insert a new record without specifying both latitude and longitude, Doctrine generates a wrong INSERT statement for PostgreSQL, including latitude and longitude as '' (empty string)
This cause this error:
SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type double precision: ""
Workaround
explicitly specifying float type for latitude and longitude...
...still generate the column correctly as double precision in the database, but will not cause any error on inserting records.
|