Heya FME specialists, another PostGIS question:
As a start I have a PointZ PostGIS table created with a PostGIS writer in workbench.
Next I have a very simple workbench to duplicate some PostGIS tables from the production server to my local server for offsite development / analyses:
I use a PostGIS FeatureReader with schema and generic because I want to dynamically create a clone of the table which is altered (data AND schema) in production without having to update readers and writers. This works wonderful!
The one problem I have is that the geometry column definition changes from PointZ to GeometryZ:
Original:
( pkey serial NOT NULL, the_geom geometry(PointZ,28992), CONSTRAINT testpoint_pkey PRIMARY KEY (pkey))Duplicate:
( pkey integer NOT NULL, the_geom geometry(GeometryZ,28992), CONSTRAINT testpoint_pkey PRIMARY KEY (pkey))I double checked to make sure the Create Generic Spatial Columns parameter is unchecked. Do I need to change another parameter or do I forget a crucial step? I attached workbenches in zip for reproduction.
FME Desktop 2016.1.1.0 (20160722 - Build 16609 - WIN32)
POSTGIS 2.1.2 (r12389)
---
Update what I tried:
In the FeatureWriter parameters, tab General, Geometry setting; From Schema Definition (original), First Feature Defines Geometry Type, postgis_point, postgis_none. The result is always a GeometryZ geometry column. Even with Dynamic Properties checked off.
Added the table as Workspace Resource combined with above settings. Still GeometryZ column.
This feels buggy to me but not a terrible problem for now as I can work around it.
---
Update filed support case:
Submitted 12-08-2016 - C118797.
