Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 498EE650125 for ; Fri, 18 Jul 2008 10:34:24 -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 36634-01 for ; Fri, 18 Jul 2008 10:34:13 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from gv-out-0910.google.com (gv-out-0910.google.com [216.239.58.190]) by postgresql.org (Postfix) with ESMTP id D0D7A650103 for ; Fri, 18 Jul 2008 10:34:18 -0300 (ADT) Received: by gv-out-0910.google.com with SMTP id i36so73442gve.7 for ; Fri, 18 Jul 2008 06:34:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=L8hUAZ4lGr0vB6kXvIIL0/KdAjtuEYHtMg4iLmKr/kU=; b=DvDcVf8ZASOqabW76GdcmTafHBYn9r9WRUZtta/Xd0WzNu7rdrWgbflsKE7CS1bhRX 6tRyImLxIAuFb3beOM1kmxjq8Od8xIZFMkL71JxefHkubcsCF6INVv9RibVv7ZurUyaT 1zO6tEhe+y6oG2He1ImBGsiDn39co/7rfLgR4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=jqJ/hpfHgnDHYswKpXMvKtyIdyMzinPPxvBzu/13ZXAmkvopP923wbEFSEM/vrODBl 47GNF8LBeDoTICHkR+f1Zs5BwJjw9Qycr8bwvBXX76E68P5O4YNPFmaK9X7zhxgwD4/c MUC8d05Bts6OXL1CblrTQIUZOkokJRTeaK/ss= Received: by 10.125.99.1 with SMTP id b1mr9167mkm.151.1216388055630; Fri, 18 Jul 2008 06:34:15 -0700 (PDT) Received: by 10.125.33.1 with HTTP; Fri, 18 Jul 2008 06:34:15 -0700 (PDT) Message-ID: <36e682920807180634o5909e5a2pb8a5446307572573@mail.gmail.com> Date: Fri, 18 Jul 2008 09:34:15 -0400 From: "Jonah H. Harris" To: "Aynur SANCAKLI" Subject: Re: unrecognized data type on dblink Cc: pgsql-admin@postgresql.org In-Reply-To: <7696f1c5400c07c6c0d02e3540897869.squirrel@mail.kamusm.gov.tr> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <7696f1c5400c07c6c0d02e3540897869.squirrel@mail.kamusm.gov.tr> 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/161 X-Sequence-Number: 29771 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/