target-postgres icon indicating copy to clipboard operation
target-postgres copied to clipboard

Map the sql type integer to the integer json type

Open dkarzon opened this issue 2 years ago • 2 comments

Make sure we can map SQL integer types to JSON integer types

dkarzon avatar Nov 04 '21 00:11 dkarzon

@dkarzon can you explain the use case for this? I just do not understand how both sql integer types are used. Not challenging the need for it, just my own understanding!

laurentS avatar Apr 12 '22 13:04 laurentS

@laurentS My use case for this is probably an odd one. I can't remember the exact scenario but I have some transforms on the data between tap and target, one of which was adding a new field to the schema of type integer. Without this fix I think target-postgres was either rebuilding the table or erroring out because it couldn't match the types.

dkarzon avatar Apr 13 '22 00:04 dkarzon