Skip to main content

I have many SQLExecutor transformers and for any reason they use to lost the geometries.

The visual preview nor the data inspector show any geometry, only a “There is no geometry in this view” message.

When they should save the results in the next FeatureWriter (in a postgis database) only the alphanumeric fields are correctly writed, but the geom field is fill with nulls.

When I execute the same sql sentence in QGis or pgAdmin I get the geom field with the correct geometries.

I'm not be able to find the fix for this issue. 
Any idea will be appreciated. Thanks in advance.

Are you querying using the PostGIS (rather than PostgreSQL).

And are you making sure to use the Result Geometry when using PostGIS:

 


Reply