Skip to main content
Released

Allow Database Writers to use Default Values

Related products:FME Form
  • July 3, 2019
  • 3 replies
  • 19 views
fmelizard
Safer
Forum|alt.badge.img+21

As an FME User, I want the PostgreSQL writer to be able to write default values if I send an empty string/missing/blank value(s) to the writer. Currently, if you want to the database to write the default value, you have to use an SQLCreator or SQLExectutor (as per the workarounds provided on the linked threads below).

This issue is currently being tracked as: FMEENGINE-8945

Related Forum Threads

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

revesz
Contributor
Forum|alt.badge.img+21
  • reveszContributor
  • Contributor
  • July 11, 2019

The default value would be welcome in SQL Server as well.

lefred06
Contributor
Forum|alt.badge.img+10
  • lefred06Contributor
  • Contributor
  • April 1, 2020

Definitely a major bug to be fixed on every database format if we want to have FME considered as a "general ETL" player.

E
  • esism
  • April 21, 2021

Hello, is there any update on this issue? We are migrating from Oracle (where such logic works perfectly) to Postgresql and this non expected behaviour gives us really hard time to workaround using functions and triggers. Thanks. Regards. Eric

Community Stats

32,207
Posts
122,305
Replies
39,892
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.