pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedunrecognized data type on dblink
3+ messages / 2 participants
[nested] [flat]
* unrecognized data type on dblink
@ 2008-07-18 13:24 Aynur SANCAKLI <aynur.sancakli@kamusm.gov.tr>
0 siblings, 1 reply; 3+ messages in thread
From: Aynur SANCAKLI @ 2008-07-18 13:24 UTC (permalink / raw)
To: pgsql-admin
Hi all,
I have a problem with dblink from oracle to postgresql.
I cannot read varchar colums from postgresql db, in the trace file the
message is in the trace file is : unrecognized data type.
How can I solve this problem
Oracle version is 10.2.0.1 on windows 2003 machine and postgresql is 8.2.3
on Centos 4.4
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: unrecognized data type on dblink
@ 2008-07-18 13:34 Jonah H. Harris <jonah.harris@gmail.com>
parent: Aynur SANCAKLI <aynur.sancakli@kamusm.gov.tr>
0 siblings, 1 reply; 3+ messages in thread
From: Jonah H. Harris @ 2008-07-18 13:34 UTC (permalink / raw)
To: Aynur SANCAKLI <aynur.sancakli@kamusm.gov.tr>; +Cc: pgsql-admin
On Fri, Jul 18, 2008 at 9:24 AM, Aynur SANCAKLI
<aynur.sancakli@kamusm.gov.tr> wrote:
> Hi all,
> I have a problem with dblink from oracle to postgresql.
>
> I cannot read varchar colums from postgresql db, in the trace file the
> message is in the trace file is : unrecognized data type.
Which Postgres ODBC driver are you using with heterogeneous services?
--
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
499 Thornall Street, 2nd Floor | jonah.harris@enterprisedb.com
Edison, NJ 08837 | http://www.enterprisedb.com/
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: unrecognized data type on dblink
@ 2008-07-19 08:49 Aynur SANCAKLI <aynur.sancakli@kamusm.gov.tr>
parent: Jonah H. Harris <jonah.harris@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Aynur SANCAKLI @ 2008-07-19 08:49 UTC (permalink / raw)
To: Jonah H. Harris <jonah.harris@gmail.com>; +Cc: pgsql-admin
I use 8.03.02.00 version driver.
> On Fri, Jul 18, 2008 at 9:24 AM, Aynur SANCAKLI
> <aynur.sancakli@kamusm.gov.tr> wrote:
>> Hi all,
>> I have a problem with dblink from oracle to postgresql.
>>
>> I cannot read varchar colums from postgresql db, in the trace file the
>> message is in the trace file is : unrecognized data type.
>
> Which Postgres ODBC driver are you using with heterogeneous services?
>
> --
> Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
> EnterpriseDB Corporation | fax: 732.331.1301
> 499 Thornall Street, 2nd Floor | jonah.harris@enterprisedb.com
> Edison, NJ 08837 | http://www.enterprisedb.com/
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-07-19 08:49 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-07-18 13:24 unrecognized data type on dblink Aynur SANCAKLI <aynur.sancakli@kamusm.gov.tr>
2008-07-18 13:34 ` Jonah H. Harris <jonah.harris@gmail.com>
2008-07-19 08:49 ` Aynur SANCAKLI <aynur.sancakli@kamusm.gov.tr>
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