Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B383864FD3E for ; Sat, 19 Jul 2008 05:49:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 45318-08 for ; Sat, 19 Jul 2008 05:49:39 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.kamusm.gov.tr (ns1.kamusm.gov.tr [193.140.71.10]) by postgresql.org (Postfix) with ESMTP id BCB46650129 for ; Sat, 19 Jul 2008 05:49:41 -0300 (ADT) Received: (qmail 23509 invoked by uid 89); 19 Jul 2008 08:49:37 -0000 Received: by simscan 1.3.1 ppid: 23501, pid: 23503, t: 0.0948s scanners: regex: 1.3.1 attach: 1.3.1 clamav: 0.92.1 /m: Received: from unknown (HELO mail.kamusm.gov.tr) (127.0.0.1) by mail.kamusm.gov.tr with SMTP; 19 Jul 2008 08:49:37 -0000 Received: from 88.233.123.24 (SquirrelMail authenticated user aynur.sancakli) by mail.kamusm.gov.tr with HTTP; Sat, 19 Jul 2008 11:49:37 +0300 (EEST) Message-ID: <3a6e9199db8820dbe57bbf706f8a9e73.squirrel@mail.kamusm.gov.tr> In-Reply-To: <36e682920807180634o5909e5a2pb8a5446307572573@mail.gmail.com> References: <7696f1c5400c07c6c0d02e3540897869.squirrel@mail.kamusm.gov.tr> <36e682920807180634o5909e5a2pb8a5446307572573@mail.gmail.com> Date: Sat, 19 Jul 2008 11:49:37 +0300 (EEST) Subject: Re: unrecognized data type on dblink From: "Aynur SANCAKLI" To: "Jonah H. Harris" Cc: pgsql-admin@postgresql.org User-Agent: SquirrelMail/1.4.15-1.3.10 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-9 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200807/167 X-Sequence-Number: 29777 I use 8.03.02.00 version driver. > On Fri, Jul 18, 2008 at 9:24 AM, Aynur SANCAKLI > 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/ >