Question

PostGIS writer updates column while not in attribute definition.

7 years ago
5 August 2016
6 replies
5 views

Userlevel 6

+33

nielsgerrits
Celebrity
2347 replies

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!

6 replies

Userlevel 4

+25

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.