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: 302
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

tqlb geqsdhqktdcf

Postby hxdrbunctsyw » Sat Sep 20, 2014 2:54 am

http://www.jerseyslivinglegend.co.je/plugins/P06/xIZx http://smokymountainportraits.com/plugins/tLH/ife http://www.3alarmseries.com/documents/JIGB/p3aY http://www.reconstyle.nl/libraries/EH6sP/8Kh0o http://www.brothertrouble.com/components/OZ0/nUI1 http://smokymountainportraits.com/plugins/tLH/Rc3 http://www.reconstyle.nl/libraries/arSV/v4rm http://www.3alarmseries.com/documents/QbrJ/I7e http://www.jerseyslivinglegend.co.je/plugins/8KM/hPHi http://www.planetzog.co.za/components/TZz61/Index.phpVyl http://www.reconstyle.nl/libraries/igF/D4YPm http://www.reconstyle.nl/libraries/Gcu/eHvdB http://terastud.ro/plugins/QFp/oEV http://www.reconstyle.nl/libraries/sUeTs/ http://www.estetska.com/pdf/7XV4/j58W http://terastud.ro/plugins/mD8c/K8VMg http://www.reconstyle.nl/libraries/AxVVN/Yjk74 http://www.tfxconnect.com/stats/7ztr/SCswN http://www.jerseyslivinglegend.co.je/plugins/djaOI/kh5D6 http://www.cse-mari.ru/backup/z9OD4/xGt http://luxusshop.hu/libraries/4Xb/WYF6M http://www.tfxconnect.com/stats/4MSn/Uy3p http://www.tfxconnect.com/stats/GLS8/ http://www.estetska.com/pdf/DwQ/hg5x http://smokymountainportraits.com/plugins/ZmylZ/eZc http://www.brothertrouble.com/components/W4da0/ http://www.3alarmseries.com/documents/F52G/EEYv http://terastud.ro/plugins/ http://www.cse-mari.ru/backup/51VMu/Yozlb http://www.3alarmseries.com/documents/0zh/ng8 http://www.brothertrouble.com/components/OZ0 http://terastud.ro/plugins/CQav/MIN8 http://www.3alarmseries.com/documents/0CV/7V5 http://luxusshop.hu/libraries/DwCNt/ http://smokymountainportraits.com/plugins/jfXC/q59sj http://www.brothertrouble.com/components/msBV/BcI http://www.cse-mari.ru/backup/7d4c/RerK http://www.jerseyslivinglegend.co.je/plugins/epSE4/X90s http://www.tfxconnect.com/stats/yN5Pz/o8D9f http://smokymountainportraits.com/plugins/LLaBm/590 http://www.estetska.com/pdf/OxOH/EyS http://www.tfxconnect.com/stats/ http://www.estetska.com/pdf/DwQ/WV8J http://luxusshop.hu/libraries/lz8/sVq7 http://terastud.ro/plugins/mD8c/fmgP http://www.cse-mari.ru/backup/I72C/9E9s http://www.estetska.com/pdf/Jjwxg/ http://www.reconstyle.nl/libraries/arSV/2ZMr http://smokymountainportraits.com/plugins/LLaBm/5KQ http://smokymountainportraits.com/plugins/huJ/7db
<a href="http://www.planetzog.co.za/components/oQP7v/Index.phplSy">http://www.planetzog.co.za/components/oQP7v/Index.phplSy</a> <a href="http://terastud.ro/plugins/QFp">http://terastud.ro/plugins/QFp</a> <a href="http://www.jerseyslivinglegend.co.je/plugins/">http://www.jerseyslivinglegend.co.je/plugins/</a> <a href="http://luxusshop.hu/libraries/nZf/m4N7">http://luxusshop.hu/libraries/nZf/m4N7</a> <a href="http://www.3alarmseries.com/documents/0CV/Otg">http://www.3alarmseries.com/documents/0CV/Otg</a> http://smokymountainportraits.com/plugins/hIg8/zExT
hxdrbunctsyw
 
Posts: 84
Joined: Sat Sep 20, 2014 2:47 am


Return to Report Bugs

Who is online

Users browsing this forum: No registered users and 1 guest

cron