Hello List

 

 

I need to be able to change the setting to create default spatial columns from YES to NO in existing workbenches writing to PostGIS.

 

 

From this question (https://safe.secure.force.com/apex/AnswersQuestionDetail?id=906a0000000ciBiAAI) and Mark's answer:

 

 

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.

 

 

I have been able to get my (new) workbenches to work the way I want them.  However, I have a number of old workbenches with the option checked.  When I connect my QGIS to PostGIS I see duplicate entries in the layer picker - one for the table with correct geometry and one for the table with unknown geometry.  Can I retrospectively edit my workbench to change this setting?

 

 

Thanks

 

 

Ross