Re: Help about types please - Mailing list pgsql-admin

From Aaron Bono
Subject Re: Help about types please
Date
Msg-id bf05e51c0608310722i7c9b7b3ey9a86b845ca112470@mail.gmail.com
Whole thread Raw
In response to Help about types please  ("Thomas Galla" <efallstar@gmail.com>)
List pgsql-admin
On 8/28/06, Thomas Galla <efallstar@gmail.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
==================================================================

pgsql-admin by date:

Previous
From: "Markus Wollny"
Date:
Subject: Re: How to convert a string to bytea?
Next
From: Tom Lane
Date:
Subject: Re: Embedded App and User Authentication