Bulk Insert on Postgres table with auto-increment UUID field fails
-
- Posts: 3
- Joined: Wed 19 Dec 2018 19:01
Bulk Insert on Postgres table with auto-increment UUID field fails
We have a table in Postgres that uses an auto-increment on a UUID field. We tried to bulk insert into that table and exclude the field with the auto-increment and the bulk insert fails. What is the best way to handle this?
-
- Posts: 3
- Joined: Wed 19 Dec 2018 19:01
Re: Bulk Insert on Postgres table with auto-increment UUID field fails
After some testing we were able to complete a bulkinsert into a test table with the same schema and column types. We think maybe the package has a schema issue. We are revisiting the original SSIS package. Thanks.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Bulk Insert on Postgres table with auto-increment UUID field fails
Can you confirm that the issue is solved?
-
- Posts: 3
- Joined: Wed 19 Dec 2018 19:01
Re: Bulk Insert on Postgres table with auto-increment UUID field fails
Here is what the developer sent today. Can you confirm that this has to do with the destination component?
We are also testing some settings. Bulk insert uses text or binary setting, and also there is a Unicode setting that may effect the results. We have that set to false when I know we are using Unicode in the Postgres database.
We are also testing some settings. Bulk insert uses text or binary setting, and also there is a Unicode setting that may effect the results. We have that set to false when I know we are using Unicode in the Postgres database.
So I just found out what the issue is with BulkInsert mode…it looks like when the Postgres data type is SMALLINT, the bulk insert fails because it’s trying to insert a NULL to the id column.
If I change the data type to INTEGER, the bulk insert works. I just tested this on the table changing the id column back and forth from SMALLINT to INT.
Looks like it’s a bug with their destination component.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Bulk Insert on Postgres table with auto-increment UUID field fails
We have reproduced the issue with a smallserial primary key. We will investigate it and post here about the results as soon as possible.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Bulk Insert on Postgres table with auto-increment UUID field fails
We have fixed the bug with Bulk Import into a PostgreSQL table with an empty value for a smallserial primary key. We will post here when the corresponding build of SSIS Data Flow Components for PostgreSQL is available for download.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Bulk Insert on Postgres table with auto-increment UUID field fails
New build of Devart SSIS Data Flow Components 1.10.959 is available for download now!
It can be downloaded from https://www.devart.com/ssis/download.html or from Devart Account (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=38889
It can be downloaded from https://www.devart.com/ssis/download.html or from Devart Account (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=38889