I have NiFi 1.7.1 version.
And I made a table in postgresql 10 db with identity column (like a sequence in old versions). But I faced with an error like:
This is a config of the PutDatabaseRecord (buttom):
And next rowid identity column (buttom):
I can fix the issue by set Unmatched Column Behaivior to Ignore or Warn, but this way is not acceptable for me for many different reasons. Is anybody know how fix this issue?
I could create the table by old method with sequence like:
and that would be ok. But I want to work with the identity column but not with sequence.
Is any suggestions?