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