Skip to main content
Question

PostGIS: Non geometry tables no longer writeable with Allowed Geometries other than 'postgis_none'

  • February 5, 2013
  • 2 replies
  • 105 views
frantsch
Contributor
Forum|alt.badge.img+4
Untill FME 2012 the PostGIS writer wrote to PostGIS tables without geometry column even though the Allowed Geometries field within the Feature Type Properties was set to other than 'postgis_none'.

 

 

Since FME 2013 this is no longer implemented, the Allowed Geometries field will strictly have to be set to 'postgis_none' in order to write to geometry-less tables.

 

 

Strictly speaking, the new behaviour is correct, of course. It however gives me a big headache changing all the dozends and hundreds of Feature Type Proberties in all my dozends of workbenches in order to make them running properly again...
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

mark2atsafe
Safer
Forum|alt.badge.img+59
  • mark2atsafeSafer
  • Safer
  • February 5, 2013
Hi

 

When you make the change to one of these types, click the button at the bottom of the dialog marked "Apply to...". It will let you pick which changes you want to make (in this case the geometry) and also which feature types to apply it to.

 

 

That should make the process a little easier.

 

 

Another setting that may help, when you add a new writer look at the properties dialog and there is a setting called "Create Generic Spatial Columns". As long as that is checked the table should be a generic one and not need a geometry type set.

 

 

Hope this helps

 

 

Mark

 

 

Mark Ireland

 

Product Evangelist, Safe Software Inc.
FME Evangelist to the Rich and Famous!!
mark2atsafe
Safer
Forum|alt.badge.img+59
  • mark2atsafeSafer
  • Safer
  • February 5, 2013
In case it helps I created a quick movie that you can find here:

 

 

http://screencast.com/t/93zP1d2yz1

 

 

Regards

 

 

Mark
FME Evangelist to the Rich and Famous!!

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.