bug 1201 - Mailing list pgsql-bugs

From federico
Subject bug 1201
Date
Msg-id 41758DFC.5020505@hyphen.it
Whole thread Raw
Responses Re: bug 1201  (Kris Jurka <books@ejurka.com>)
Re: bug 1201  (Federico Fissore <fissore@hyphen.it>)
List 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)
RETURNS void AS
$BODY$
    UPDATE    table
    SET    field1 = $1
    WHERE    field2 = $2;
$BODY$
LANGUAGE 'sql' VOLATILE;


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
returntype 
    at org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
    at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
    at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
    at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
    at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)


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

thank you

federico

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #1286: indices not used after a pg_restore
Next
From: Kris Jurka
Date:
Subject: Re: bug 1201