Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 27 Jul 2007 00:24:05 +0200
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
- Follow-Ups:
- Re: Bug in SQL for set returning functions
- From: Dave Page
- Re: Bug in SQL for set returning functions
- Prev by Date: Re: pgAdmin III v1.8.0 Beta 2 released
- Next by Date: SVN Commit by dpage: r6498 - trunk/pgadmin3/pgadmin/schema
- Previous by thread: SVN Commit by dpage: r6497 - trunk/www/download
- Next by thread: Re: Bug in SQL for set returning functions
- Indexes: