Re: [BUGS] BUG #1201: void functions called through jdbc driver

#1

On Tue, 27 Jul 2004, PostgreSQL Bugs List wrote:

Quote:

Bug reference: 1201
Logged by: Jonathan Scott
Email address: jwscott (AT) vanten (DOT) com
PostgreSQL version: 7.4
Description: void functions called through jdbc driver return error

At work here, we are considering upgrading from 7.3 to 7.4, but we've hit a
bit of a snag. We have functions in our schema that have return void. When
called through the 7.4's JDBC driver, we get the following error:

ERROR: function "fulfill_cctrans_item" in FROM has unsupported return type

To elaborate more on this problem after it gets past the jdbc driver, what
happens is that the function call execution is translated into a SQL
statement of the form "SELECT * FROM voidfunc();" This produces a server
error message:

CREATE OR REPLACE FUNCTION voidfunc() RETURNS void AS
'begin return; end;'
LANGUAGE plpgsql;

SELECT * FROM voidfunc();

ERROR: function "voidfunc" in FROM has unsupported return type

It is unclear why this is disallowed. A plain "SELECT voidfunc();" works.

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] BUG #1201: void functions called through jdbc driver

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] BUG #1201: void functions called through jdbc driver - 07-27-2004 , 01:57 AM