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

bug 1201

From: federico <fissore(at)hyphen(dot)it>
To: pgsql-bugs(at)postgresql(dot)org
Subject: bug 1201
Date: 2004-10-19 21:58:20
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
i saw in bug 1201 that some got my problem
i detail it
i have a function that returns a void

CREATE OR REPLACE FUNCTION myFunction(int2, int2)
	UPDATE	table 
	SET	field1 = $1 
	WHERE	field2 = $2;

when i execute it with a callablestatement

CallableStatement cstm = conn.prepareCall({ call myFunction(CAST(? AS INT2), CAST(? AS INT2)) });
cstm.setInt(1, aValue.getValue());
cstm.setInt(2, anotherValue.getValue());

i got the following error

org.postgresql.util.PSQLException: ERROR: function "jcpo_setallusersbyissuemessagestatus" in FROM has unsupported return type
    at org.postgresql.util.PSQLException.parseServerError(
    at org.postgresql.core.QueryExecutor.executeV3(
    at org.postgresql.core.QueryExecutor.execute(
    at org.postgresql.core.QueryExecutor.execute(
    at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(

any news about it?
i'm using PostgreSQL Database Server 8.0-beta2-dev3 on Windows and 
pgdev.307.jdbc3.jar drivers

thank you



pgsql-bugs by date

Next:From: Kris JurkaDate: 2004-10-19 23:23:07
Subject: Re: bug 1201
Previous:From: Tom LaneDate: 2004-10-19 21:23:43
Subject: Re: BUG #1286: indices not used after a pg_restore

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