X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C24469FB3F5 for ; Thu, 31 Aug 2006 11:24:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 97020-02-7 for ; Thu, 31 Aug 2006 11:24:36 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.176]) by postgresql.org (Postfix) with ESMTP id 88F7B9FB3EF for ; Thu, 31 Aug 2006 11:22:43 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id d80so752982pyd for ; Thu, 31 Aug 2006 07:22:41 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=dgLV0Rxsn0lGLi9t2Xf+MiNVKtfHB3YmG1NnL+YcLWkuK+MweCfn4PPBr3E8QCZolnOtWq4Vyv4bLHmYQPWWapL0BtMC/gywIx44LeCML2Mcz6XiZlg5phAYmlShCvmKZyx2DL0e/4+C+tM2aP6HQKWHHg4slbj9dXeL3iZoHmM= Received: by 10.35.41.12 with SMTP id t12mr822850pyj; Thu, 31 Aug 2006 07:22:41 -0700 (PDT) Received: by 10.35.80.9 with HTTP; Thu, 31 Aug 2006 07:22:41 -0700 (PDT) Message-ID: Date: Thu, 31 Aug 2006 09:22:41 -0500 From: "Aaron Bono" To: "Thomas Galla" Subject: Re: Help about types please Cc: pgsql-admin@postgresql.org In-Reply-To: <942eab230608281525s711395fbx4e8a5ad7f45618ae@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_53543_4799719.1157034161516" References: <942eab230608281525s711395fbx4e8a5ad7f45618ae@mail.gmail.com> X-Google-Sender-Auth: b2ee8c580f3f03b2 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.571 tagged_above=0 required=5 tests=AWL, HTML_30_40, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/346 X-Sequence-Number: 22889 ------=_Part_53543_4799719.1157034161516 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 8/28/06, Thomas Galla wrote: > > Hello everyone, > > Actually i'm working in a java project which attemps to storage oid data > types in a postgres7.4. > > Anyway, when my application tries to store an oid, it throws a > sqlexception that says: > > ERROR: the column =ABdoc_cidt=BB is of type oid but yhe expression is of = type > bytea > > i'll give you my thanks if someone can helpme with this problem. > > PD: I also update my postgres to the 8.1 version, but it still don't > works. A!, and it occurs on linux plattform (on windows it works properly= ) > Can you provide your query/queries that you are using to do this? Also lis= t the tables and column types for tables you are selecting from and inserting into. =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D ------=_Part_53543_4799719.1157034161516 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 8/28/06, Thomas Galla <efallstar@gmail.com> wrote:
Hello everyone,

Actually i'm working in a java project which at= temps to storage oid data types in a postgres7.4.

Anyway, when my ap= plication tries to store an oid, it throws a sqlexception that says:

ERROR: the column =ABdoc_cidt=BB is of type oid but yhe expression is o= f type bytea

i'll give you my thanks if someone can helpme with this problem.
PD: I also update my postgres to the 8.1 version, but it still don't w= orks. A!, and it occurs on linux plattform (on windows it works properly)


Can you provide your query/q= ueries that you are using to do this?  Also list the tables and column types for tables you are selecting from and inserting into.

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D   Aaron Bono
   Aranya Software Technologies, Inc.=
   http://www.aranya.com
  
http://codeelixir.com
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D ------=_Part_53543_4799719.1157034161516--