[postgis-tickets] [PostGIS] #3278: MySQL FDW Issues with Geometry Type

[PostGIS]

#3278: MySQL FDW Issues with Geometry Type
--------------------------+------------------------------------------
  Reporter:  ryckingnoaa  |      Owner:  pramsey
      Type:  defect       |     Status:  closed
  Priority:  medium       |  Milestone:  PostGIS 2.1.9
 Component:  postgis      |    Version:  2.1.x
Resolution:  worksforme   |   Keywords:  MySQL FDW, geometry, polygon
--------------------------+------------------------------------------
Changes (by robe):

 * status:  new => closed
 * resolution:   => worksforme


Comment:

 1) Yes that issue was fixed.  In fact I have a database with a bunch of
 foreign tables (using ogr_fdw driver) which I get listed when I do:


 {{{
 SELECT * FROM geometry_columns;
 }}}


 The geometry_columns view is just a table that lists all database columns
 of type geometry.  Not sure what you think it is or if you have it
 confused with something else.

 2) The fact you are not seeing some records coming thru from your
 mysql_fdw table sounds like it might be an issue with the mysql_fdw
 driver.  I don't use that driver so don't know.  You might want to report
 your issue to them and maybe turn on logging on your database if you don't
 have it already to see if there is something spitting out.

 All my foreign tables where I output PostGIS use the ogr_fdw driver
 https://github.com/pramsey/pgsql-ogr-fdw


 and all records that are supposed to be there show up when I query them.
 This is from a variety of different spatial data sources.

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3278#comment:1>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.