On 03/23/2018 03:55 AM, Patricia DECHANDOL wrote:
Hello,
I’m new to Postgresql and try to use the FDW with mysql database.
Everything is OK to create my FDW and foreign tables, but I meet a
problem when I try to do a select on a FOREIGN table containing datetime
column which contains the value “0000-00-00 00:00:00” in mysql.
That is MySQL's version of NULL for datetimes. It is not a valid
datetime though.
Select on the foreign table fails.
The mysql datetime column has been automatically wrapped to “timestamp
without timezone” column in the foreign table by the instruction “import
foreign schema” that I used.
How can I deal with this ?
https://github.com/EnterpriseDB/mysql_fdw/issues/38
I read about the pgloader with can manage this king of problem, but
can’t figure out how to use it with FDW.
Thanks for your help.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
