Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 606821337B69 for ; Wed, 11 May 2011 09:48:19 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 33942-02 for ; Wed, 11 May 2011 12:48:12 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.cybertec.at (mail.cybertec.at [87.118.110.48]) by mail.postgresql.org (Postfix) with ESMTP id 214FE1337B67 for ; Wed, 11 May 2011 09:48:12 -0300 (ADT) Received: from [192.168.0.13] (home [84.115.25.80]) by mail.cybertec.at (Postfix) with ESMTP id 9DFC25FC2B6; Wed, 11 May 2011 14:36:40 +0200 (CEST) Subject: Re: Question about odbc link to Oracle database from PostgreSQL Mime-Version: 1.0 (Apple Message framework v1084) Content-Type: text/plain; charset=iso-8859-1 From: =?iso-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= In-Reply-To: Date: Wed, 11 May 2011 14:48:11 +0200 Cc: pgsql-admin@postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: References: To: Hsien-Wen Chu X-Mailer: Apple Mail (2.1084) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201105/84 X-Sequence-Number: 37521 hello ... read this: ERROR: type "number" does not exist we don't have this type. use numeric or whatever matches. many thanks, hans On May 11, 2011, at 2:46 PM, Hsien-Wen Chu wrote: > ERROR: type "number" does not exist -- Cybertec Sch=F6nig & Sch=F6nig GmbH Gr=F6hrm=FChlgasse 26 A-2700 Wiener Neustadt, Austria Web: http://www.postgresql-support.de