Re: Help about types please

From: "Aaron Bono" <postgresql(at)aranya(dot)com>
To: "Thomas Galla" <efallstar(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Help about types please
Date: 2006-08-31 14:22:41
Message-ID: bf05e51c0608310722i7c9b7b3ey9a86b845ca112470@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 8/28/06, Thomas Galla <efallstar(at)gmail(dot)com> 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 «doc_cidt» 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 list
the tables and column types for tables you are selecting from and inserting
into.

==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
http://codeelixir.com
==================================================================

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-08-31 14:26:58 Re: Embedded App and User Authentication
Previous Message Markus Wollny 2006-08-31 13:41:51 Re: How to convert a string to bytea?