Bug in SQL for set returning functions - Mailing list pgadmin-hackers

From Erwin Brandstetter
Subject Bug in SQL for set returning functions
Date
Msg-id 46A91F05.6080409@falter.at
Whole thread Raw
Responses Re: Bug in SQL for set returning functions
List 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

pgadmin-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: pgAdmin III v1.8.0 Beta 2 released
Next
From: svn@pgadmin.org
Date:
Subject: SVN Commit by dpage: r6498 - trunk/pgadmin3/pgadmin/schema