Skip to main content
Question

problems with dropping tables before update (postGIS)

R
Forum|alt.badge.img
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
Contributor
Forum|alt.badge.img+17
  • fmelizardContributor
  • Contributor
  • April 10, 2014
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
Forum|alt.badge.img
  • rkcha
  • Author
  • April 10, 2014
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
Contributor
Forum|alt.badge.img+17
  • fmelizardContributor
  • Contributor
  • April 10, 2014
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


Most helpful members this week

Community Stats

30,847
Posts
116,943
Replies
38,670
Members
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.