Bug in SQL for set returning functions

From: Erwin Brandstetter <brandstetter(at)falter(dot)at>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Bug in SQL for set returning functions
Date: 2007-07-26 22:24:05
Message-ID: 46A91F05.6080409@falter.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hi developers!

Testing the pgAdmin III 1.8.0 Beta 2 (Jul 25 2007, rev: 6486). Client
Win XP, host: Debian Sarge / PG 8.1.8 and Debian Etch / PG 8.2.4

I am afraid beta2 has introduced a new bug in the reverse engineering of
SQL code. SET returning functions get two instances of the the "RETURNS
" clause. Like this:

CREATE OR REPLACE FUNCTION f_demofunc(IN integer, OUT integer)
RETURNS SETOF record
RETURNS SETOF record AS
$BODY$
...

Does not seem to happen with simple return types.

Regards
Erwin

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message svn 2007-07-27 08:21:37 SVN Commit by dpage: r6498 - trunk/pgadmin3/pgadmin/schema
Previous Message Dave Page 2007-07-26 19:13:29 Re: pgAdmin III v1.8.0 Beta 2 released