Skip to main content
  • EN
Hi all,

 

 

Just upgrading to the pro edition, and what a edition! 🙂 Using the WFS reader to update a table in our local database (postGIS). So far so good. I want to run the workspace as a batch updating the table every night, which means I want to delete the content of the table before updating it. Somehow this dosen´t seem to work. I tried to google the answer, setting the parameter in the postGIS writer to UPDATE. Not working. Something I´ve missed?

 

 

I´m using FME 2014 SP1

 

 

Christian

 

 

Link to Workspace screenshot:

 

 

https://dl.dropboxusercontent.com/u/8365323/WFS%20%E2%86%92%20POSTGIS.png

 

Hi,

 

Make sure the truncate table setting on the writer is set to yes and on INSERT instead of UPDATE. Check to make sure that the create table is set to no.
Hi,

 

 

thanks for the answer. I´m uncertain about the create table parameter. Where is it located? 

 

 

https://dl.dropboxusercontent.com/u/8365323/properties.png

 

yes, I see your point 🙂 I am so used to it being there as an oracle user.....apperently the approach is slightly different in PostGIS.

 

The documentation (http://docs.safe.com/fme/html/FME_ReadersWriters/Default.htm#postgis/Writer_Directives.htm)indicate that the table name and other writer parameters control overwritting or appending. Always a good place to start from when in doubt.

Reply


Community Stats

30,108
Posts
114,292
Replies
37,743
Members
Terms & ConditionsCookie settings
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.