Postgres: Error bulk inserting into a table with default column value
Posted: Fri 25 Aug 2017 00:43
I'm trying to bulk load data into a postgres table which has a default value defined for the first column (id), using a sequence.
When trying to run the process, I get the following error immediately ;
[Devart PostgreSql Destination] Error: An exception has occured during data processing, the message returned from the provider is:
Column with name id does not exist.
However, if I change the target table so that the id column does not have a default value defined, the process runs.
The process also runs fine when set to a simple Insert.
I'm running the latest build of the Data Flow Components, Postgres version 9.6, and Integration services 2016.
Any ideas ?
When trying to run the process, I get the following error immediately ;
[Devart PostgreSql Destination] Error: An exception has occured during data processing, the message returned from the provider is:
Column with name id does not exist.
However, if I change the target table so that the id column does not have a default value defined, the process runs.
The process also runs fine when set to a simple Insert.
I'm running the latest build of the Data Flow Components, Postgres version 9.6, and Integration services 2016.
Any ideas ?