Question

problems with dropping tables before update (postGIS)

  • 10 April 2014
  • 3 replies
  • 1 view
R
Badge
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

 

3 replies

fmelizard
Rank
Userlevel 4
Badge +13
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.
R
Badge
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

 

fmelizard
Rank
Userlevel 4
Badge +13
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

28,724
Posts
109,518
Replies
36,564
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.