Skip to main content
Question

Cannot write string value of NULL to Postgres column with not null constraint if Bulk Insert set to Yes - Known Issue?

ebygomm
Influencer
Forum|alt.badge.img+38

With a postgres writer it appears that if Bulk Insert is set to Yes, if you attempt to write a string value of NULL to a varchar column that has a Not Null constraint it is interpreted as a genuine null and results in a fatal error

Error was 'ERROR:  null value in column "value" violates not-null constraint

If Bulk Insert is set to No, the value is written as a string as expected

 

Is this a known issue? This is in FME(R) 2021.2.6.0 (20220727 - Build 21821) so may have already been addressed.

2 replies

nampreetatsafe
Safer
Forum|alt.badge.img+13

Hi @ebygomm​. Apologies for not noticing this earlier. I'm sorry you came across this issue. I managed to reproduce it, and have filed a ticket with our development team (internal reference: FMEENGINE-78517). We'll try to provide an update here when the ticket has been addressed.

jovitaatsafe
Safer
Forum|alt.badge.img+11

Hi @ebygomm​, I'm happy to report that the issue @nampreetatsafe​ had filed on your behalf has been addressed by development, and a fix is available in Betas for testing which is now available here: engage.safe.com/support/downloads/beta

 

Please let us know how that goes and reach out any time if you have any feedback on the fix. Thanks!

Reply


Helpful Members This Week

Community Stats

31,340
Posts
118,850
Replies
38,930
Members

Latest FME

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.