demetrixbio / FSharp.Data.Npgsql

F# type providers to support statically typed access to input parameters and result set of sql statement in idiomatic F# way. Data modifications via statically typed tables.
Apache License 2.0
128 stars 15 forks source link

Identity columns and binary import #89

Closed kerams closed 2 years ago

kerams commented 4 years ago

When doing a binary import using a DataTable into a table with an identity column, the TP tries to write a 0 when not explicitly set in AddRow, causing a row with incorrect data to be written, followed by key violations if the column in question is constrained.