Skip to main content
Question

PostGIS writer updates column while not in attribute definition.

nielsgerrits
VIP
Forum|alt.badge.img+54

Heya FME specialists, can you please give a thought on the next issue:

Created a new table in PostGIS with FME from shape, using the PostGIS writer. (see 00_initiate.fmw)

 

Point feature, attributes pkey and a, b, c with values. Insert, drop and create.

Updated this table with the PostGIS writer. (see 01_update.fmw)

 

Point feature, pkey, and only a, b with values. Update based on pkey, use existing.

The problem is: We decided to maintain attribute c with QGIS directly in PostGIS but kept editing the geometry and attributes a and b in the shape. I deleted the attribute c in the writer assuming it wouldn't write it anymore to the database. That assumption appeared to be wrong and to prevent updating attribute c I had to use an AttributeKeeper in front of the PostGIS writer. My problem solved but curious if this is a DB writer syntax or a bug?

Using FME Desktop 2016.1.0.1 on Windows 7. Uploaded workbenches in zip for reproduction.

Thanks!

1 Attachments

7 replies

mark2atsafe
Safer
Forum|alt.badge.img+45
  • mark2atsafeSafer
  • Safer
  • August 5, 2016
Do you have the log file for the incorrect behaviour? That may tell us what SQL statement is being used to update the data. It would be interesting to see if that attribute is part of it. Either way I will file a report to our developers and see if they think it's a bug that needs fixing.

 

 

mark2atsafe
Safer
Forum|alt.badge.img+45
  • mark2atsafeSafer
  • Safer
  • August 5, 2016
Filed with development as PR#71568

 

 

nielsgerrits
VIP
Forum|alt.badge.img+54
mark2atsafe wrote:
Do you have the log file for the incorrect behaviour? That may tell us what SQL statement is being used to update the data. It would be interesting to see if that attribute is part of it. Either way I will file a report to our developers and see if they think it's a bug that needs fixing.

 

 

Not sure what log you need exactly? The FME log with debug on doesn't show the update statement.

 

 

david_r
Celebrity
  • david_rCelebrity
  • August 8, 2016
mark2atsafe wrote:
Filed with development as PR#71568

 

 

This sounds oddly familiar, I have a feeling I've already filed this a long time ago...
mark2atsafe
Safer
Forum|alt.badge.img+45
  • mark2atsafeSafer
  • Safer
  • August 8, 2016
nielsgerrits wrote:
Not sure what log you need exactly? The FME log with debug on doesn't show the update statement.

 

 

Sometimes it does, but I guess sometimes it doesn't. Oh well. We'll see what the developers say.

 

 

arthur_bazin
Contributor
Forum|alt.badge.img+14
  • arthur_bazinContributor
  • Contributor
  • February 19, 2020

Hi @mark2atsafe, is it possible to have information about the resolution of this trouble ?

I think I have something similar with the last version of FME (2019.2) but not in the previous version (2019.1).

Thank's

Tips & tricks with data : https://blog.arthurbazin.com
mark2atsafe
Safer
Forum|alt.badge.img+45
  • mark2atsafeSafer
  • Safer
  • August 20, 2024

It’s very late, I know, but I can confirm that this issue is fixed. 2024.2 is the version containing the fix.

Reply


Helpful Members This Week

Community Stats

31,477
Posts
119,332
Replies
39,092
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

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.