Skip to main content
Question

Bad column type in postgreSQL : how to not skip features ?


user01
Contributor
Forum|alt.badge.img+2

Hello,

 

I want to write features in postgreSQL. Because of a bad type of a table column some features are not written. Alert message for one of them :

210 Value of attribute 'idrlt' could not be converted to type 'int4'. Feature will be logged and skipped

I want them to be logged BUT written too (not skipped).

 

Is it possible ?

 

Thank you

2 replies

david_r
Evangelist
  • October 20, 2021

You could use an AttributeValidator to check for invalid values, e.g. strings where there should be integers, and then perhaps try to fix those values yourself.


user01
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • October 20, 2021

Thank you, I didn't know this transformer. This is a good idea for few columns to check. The problem is that I have thousands of columns to check... but there are fews possible types so maybe I can figure out. Thanks !


Reply


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