From gataric@usa.net Mon Oct 15 00:52:24 2012 Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TNYuu-0003rJ-Ha for pgsql-general@postgresql.org; Mon, 15 Oct 2012 00:52:24 +0000 Received: from cmsout01.mbox.net ([165.212.64.31]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TNYum-0007wm-Uf for pgsql-general@postgresql.org; Mon, 15 Oct 2012 00:52:24 +0000 Received: from co01.mbox.net (localhost [127.0.0.1]) by cmsout01.mbox.net (Postfix) with ESMTP id 3087966838A for ; Mon, 15 Oct 2012 00:52:13 +0000 (UTC) X-USANET-Received: from co01.mbox.net [127.0.0.1] by co01.mbox.net via mtad (C8.MAIN.3.82G) with ESMTP id 830qJoa1k5312M01; Mon, 15 Oct 2012 00:52:10 -0000 X-USANET-Routed: 3 gwsout-vs Q:bmvirus Received: from imap02.cms.usa.net [165.212.11.2] by co01.mbox.net via smtad (C8.MAIN.3.87D) with ESMTP id XID830qJoa1k4305X01; Mon, 15 Oct 2012 00:52:10 -0000 X-USANET-Source: 165.212.11.2 OUT gataric@usa.net imap02.cms.usa.net X-USANET-MsgId: XID830qJoa1k4305X01 Received: from Alexoffice [24.12.102.168] by imap02.cms.usa.net (ESMTPSA/gataric@usa.net) via mtad (C8.MAIN.3.82G) with ESMTPSA id 588qJoa1k4704M22; Mon, 15 Oct 2012 00:52:10 -0000 X-USANET-Auth: 24.12.102.168 AUTH gataric@usa.net Alexoffice From: "Alexander Gataric" To: References: <201209270859.09943.andres@2ndquadrant.com> In-Reply-To: Subject: Mapping PostgreSQL data types to DB2 Federated Server Date: Sun, 14 Oct 2012 19:52:09 -0500 Message-ID: <00eb01cdaa6f$4ea12d90$ebe388b0$@net> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00EC_01CDAA45.65CB2590" X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: Ac2qbsAf0BBEMQnWT6u+82i6+86LqQAAGYNg Content-Language: en-us Z-USANET-MsgId: XID588qJoa1k4704X22 X-Pg-Spam-Score: 0.0 (/) X-Archive-Number: 201210/435 X-Sequence-Number: 191403 This is a multi-part message in MIME format. ------=_NextPart_000_00EC_01CDAA45.65CB2590 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hello, I'm on a project which requires adding PostgreSQL tables to DB2 Federated Server. I'm getting an error with PostgreSQL data types boolean, text, bytea, and XML. I believe this can be solved with the CREATE TYPE MAPPING in Fed Server. Does anyone know which values to use? I'm not that familiar with Fed Server. Also, the Postgres data is being extracted and inserted from the same table using Optim Archive. Does this pose an additional challenge with setting up the mapping? Thank you in advance Alex ------=_NextPart_000_00EC_01CDAA45.65CB2590 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hello,

I'm on a project which requires adding PostgreSQL tables to DB2 = Federated Server. I'm getting an error with PostgreSQL data types = boolean, text, bytea, and XML. I believe this can be solved with the = CREATE TYPE MAPPING in Fed Server. Does anyone know which values to use? = I'm not that familiar with Fed Server.

Also, the Postgres data is being extracted and inserted from the same = table using Optim Archive. Does this pose an additional challenge with = setting up the mapping?

Thank you in advance

Alex

 

------=_NextPart_000_00EC_01CDAA45.65CB2590-- From pierce@hogranch.com Mon Oct 15 01:05:44 2012 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TNZ7o-0001B0-2p for pgsql-general@postgresql.org; Mon, 15 Oct 2012 01:05:44 +0000 Received: from hogranch.com ([75.101.82.47]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TNZ7i-0006B2-Dt for pgsql-general@postgresql.org; Mon, 15 Oct 2012 01:05:43 +0000 Received: from [192.168.0.2] (porker [192.168.0.2]) by hogranch.com (8.11.6/8.11.6) with ESMTP id q9F15X913172 for ; Sun, 14 Oct 2012 18:05:33 -0700 Message-ID: <507B6158.1020200@hogranch.com> Date: Sun, 14 Oct 2012 18:05:28 -0700 From: John R Pierce User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:16.0) Gecko/20121010 Thunderbird/16.0.1 MIME-Version: 1.0 To: pgsql-general@postgresql.org Subject: Re: Mapping PostgreSQL data types to DB2 Federated Server References: <201209270859.09943.andres@2ndquadrant.com> <00eb01cdaa6f$4ea12d90$ebe388b0$@net> In-Reply-To: <00eb01cdaa6f$4ea12d90$ebe388b0$@net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-HawgScanner-Information: Please contact the ISP for more information X-HawgScanner: Found to be clean X-Pg-Spam-Score: -2.3 (--) X-Archive-Number: 201210/436 X-Sequence-Number: 191404 On 10/14/12 5:52 PM, Alexander Gataric wrote: > > I'm on a project which requires adding PostgreSQL tables to DB2 > Federated Server. I'm getting an error with PostgreSQL data types > boolean, text, bytea, and XML. I believe this can be solved with the > CREATE TYPE MAPPING in Fed Server. Does anyone know which values to > use? I'm not that familiar with Fed Server. > > Also, the Postgres data is being extracted and inserted from the same > table using Optim Archive. Does this pose an additional challenge with > setting up the mapping? > I suggest you talk to your IBM support contacts for these issues, they really have little to do with Postgres and are completely beyond postgres' control. -- john r pierce N 37, W 122 santa cruz ca mid-left coast