Transform simple geometry to multiple geometry before postgis integration
Dear FME community.
I've to extract geometries from ORACLE SDO GEOMETRY for insert them into Postgis DataBase.
The geometries in Postgis must be with type 'MULTILINESTRING' but my ORACLE SDO GEOMETRY are in 'LINESTRING'.
I try this solutions :
In postgis : to make a trigger for transform geometries before integration with postgis function ST_Multi but that don't work.
In FME : to use GeometryCoercer but all geometries are untouched
In FME : to use GeometryRefiner without success
In ORACLE : to transform the source geometry but that doesn't works
Any idea ?
Maybe I'm missing something, but have you tried reading them from Oracle and directly writing them to PostGIS? (in other words: let the writer sort it out without tinkering with it)
Have you tried to use the Aggregator transformer?
In the "Group By" you should put the primary key field.
