Domain support

Report PGNP bugs.

Domain support

Postby adeboisanger » Wed Jun 15, 2011 6:15 am

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
adeboisanger
 
Posts: 2
Joined: Wed Jun 15, 2011 6:00 am

Re: Domain support

Postby Moderator » Wed Jun 15, 2011 12:07 pm

We are working on the fix. Thank you!
User avatar
Moderator
Site Admin
 
Posts: 296
Joined: Wed Oct 29, 2008 11:27 pm

Re: Domain support

Postby adeboisanger » Thu Jul 07, 2011 12:24 am

Thank you for the fix :)
It is working great !
adeboisanger
 
Posts: 2
Joined: Wed Jun 15, 2011 6:00 am


Return to Report Bugs

Who is online

Users browsing this forum: No registered users and 1 guest