Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group