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

Re: bug 1201

From: Federico Fissore <fissore(at)hyphen(dot)it>
To:
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: bug 1201
Date: 2004-10-21 07:32:16
Message-ID: 41776600.2040906@hyphen.it (view raw or flat)
Thread:
Lists: pgsql-bugs
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
>


In response to

  • bug 1201 at 2004-10-19 21:58:20 from federico

pgsql-bugs by date

Next:From: Tom LaneDate: 2004-10-21 14:58:41
Subject: Re: BUG #1290: Default value and ALTER...TYPE
Previous:From: Tom LaneDate: 2004-10-21 04:19:38
Subject: Re: [HACKERS] BUG #1290: Default value and ALTER...TYPE

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