Domain support

[adeboisanger]

Hi,

We are using PGNP to import data from Postgres to SQL Server by using SSIS.
We have problems when importing Domains in our SSIS Package. Instead of a smallint of value -1 it retrieves a nvarchar(4000) of value “45”.

Here is the creation script of one of the domains in postgres :

CREATE DOMAIN SchemaName.enum_transferts
AS smallint
NOT NULL
CONSTRAINT enum_transferts_check CHECK ((((((((((VALUE = (-1)) OR (VALUE = 0)) OR (VALUE = 2)) OR (VALUE = 3)) OR (VALUE = 5)) OR (VALUE = 6)) OR (VALUE = 7)) OR (VALUE = 8)) OR (VALUE = 9)));
ALTER DOMAIN SchemaName.enum_transferts OWNER TO OwnerName;
COMMENT ON DOMAIN SchemaName.enum_transferts IS '-1 = RIEN


Thank you.

Audran

[Moderator]

We are working on the fix. Thank you!

[adeboisanger]

Thank you for the fix
It is working great !