some trouble in Point datatypes

[zhouyinchi]

I import mysql table into psql table, but can't convert mysql point type into psql point type; which lead to Error" invailid input syntax for type point "

[surajkharage19]

Thanks, @zhouyinchi for raising this issue.

I am able to reproduce the issue at my end. I can see that point is a geometry data type and none of the geometry data types is handled in mysql_fdw as of now. We do not have an immediate plan to support this, however, if you have patches ready for this functionality please feel free to submit them here, we will take this further and try to commit if everything goes well.

[zhouyinchi]

Thanks @surajkharage19. I manage to create a view which transform point into WKT text. And then everything is ok. By the way I am a frontEnd developer, So It's hard for me to submit anything here

[latot]

Hi! this still happens, today I was trying this with Dolt/MySQL and postgres, sadly we can't move geometries between dbs.

[surajkharage19]

Hi @latot,

As mentioned above, this is not fixed yet and we do not have any immediate plan to fix the same. Can you please try the workaround given above by yinchi Zhou. https://github.com/EnterpriseDB/mysql_fdw/issues/260#issuecomment-1340670037

[latot]

Hi, I'm trying to do it, but seems not easy, mysql_fdw uses the OID, but for extensions, the OID of the extension types changes and there is no standard (I have checked this with postgres ppl).

So I don't know how @zhouyinchi know is working with a geometry...

[surajkharage19]

@zhouyinchi, Would you be able to share the workaround tried at your end to help @latot?

[latot]

Half half, asking in postgis, there is a fdw for geometries too!

https://github.com/pramsey/pgsql-ogr-fdw

I think worth to check it.