Binary COPY is strict about types and does no implicit cast, so writing a Kind=Utc DateTime to a timestamp without time zone column throws a low-level Npgsql converter error. The parameterized insert path hides this via driver inference + implicit cast.
Options to consider:
At minimum this is documented on the Bulk COPY page; a friendlier runtime experience would help.
Binary COPY is strict about types and does no implicit cast, so writing a
Kind=UtcDateTimeto atimestamp without time zonecolumn throws a low-level Npgsql converter error. The parameterized insert path hides this via driver inference + implicit cast.Options to consider:
DateTime.Kindto match the column's timestamp type.At minimum this is documented on the Bulk COPY page; a friendlier runtime experience would help.