pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedMapping PostgreSQL data types to DB2 Federated Server
2+ messages / 2 participants
[nested] [flat]
* Mapping PostgreSQL data types to DB2 Federated Server
@ 2012-10-15 00:52 Alexander Gataric <gataric@usa.net>
0 siblings, 1 reply; 2+ messages in thread
From: Alexander Gataric @ 2012-10-15 00:52 UTC (permalink / raw)
To: pgsql-general@postgresql.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Mapping PostgreSQL data types to DB2 Federated Server
@ 2012-10-15 01:05 John R Pierce <pierce@hogranch.com>
parent: Alexander Gataric <gataric@usa.net>
0 siblings, 0 replies; 2+ messages in thread
From: John R Pierce @ 2012-10-15 01:05 UTC (permalink / raw)
To: pgsql-general@postgresql.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2012-10-15 01:05 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-10-15 00:52 Mapping PostgreSQL data types to DB2 Federated Server Alexander Gataric <gataric@usa.net>
2012-10-15 01:05 ` John R Pierce <pierce@hogranch.com>
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