thank you for your attention
kris, i'll keep the patch but i won't patch my pgsql because i cannot tell my "customers" (it's a OS program; if it will run ok, maybe my company will switch from mssql to pgsql) to patch their pgsql installation.
i look forward for the final release of pgsql 8 and of the jdbc drivers
thank you
federico
federico wrote:
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 return type
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
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
