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

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 (view raw or flat)
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

pgadmin-hackers by date

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

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