Question

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

  • 20 October 2021
  • 2 replies
  • 1 view

Badge +1

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

Userlevel 4

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.

Badge +1

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