[ADMIN] how to read bytea column from dblink

Hi, I try to read bytea column from postgresql db over a dblink in Oracle DB. But I could not. How can I solve the problem? In windows environment there is a parameter in odbc driver bytea as LO. I could not find how to set it on unix odbc. Versions of products I Use: Postgresql 8.3.3 on redhat

Re: [ADMIN] unrecognized data type on dblink

I use 8.03.02.00 version driver. > On Fri, Jul 18, 2008 at 9:24 AM, Aynur SANCAKLI > <[EMAIL PROTECTED]> 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 th

[ADMIN] unrecognized data type on dblink

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.