pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: John R Pierce <pierce@hogranch.com>
To: pgsql-general@postgresql.org
Subject: Re: Mapping PostgreSQL data types to DB2 Federated Server
Date: Sun, 14 Oct 2012 18:05:28 -0700
Message-ID: <507B6158.1020200@hogranch.com> (raw)
In-Reply-To: <00eb01cdaa6f$4ea12d90$ebe388b0$@net>
References: <CAGYUkGVcfYY57WPjqCEaZt7akyz3d0pBJ8QOq3L+i6O=CujMmw@mail.gmail.com>
	<201209270859.09943.andres@2ndquadrant.com>
	<CAGYUkGVsrZ0iqXEdX5D4seYg-=bJuZGZyrOL7WZh5gL=9A5wrw@mail.gmail.com>
	<00eb01cdaa6f$4ea12d90$ebe388b0$@net>

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





view thread (2+ messages)

Message-ID: <507B6158.1020200@hogranch.com>
Permalink:  ../507B6158.1020200@hogranch.com/
Also on:    postgresql.org/message-id/507B6158.1020200@hogranch.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: pierce@hogranch.com, pgsql-general@postgresql.org
  Subject: Re: Mapping PostgreSQL data types to DB2 Federated Server
  In-Reply-To: <507B6158.1020200@hogranch.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox