[pgAdmin III] #188: Properties dialog for functions returning TABLE() broken. - Mailing list pgadmin-hackers

#188: Properties dialog for functions returning TABLE() broken.
---------------------+------------------------------------------------------
 Reporter:  brsa     |       Owner:  dpage 
     Type:  bug      |      Status:  new   
 Priority:  major    |   Milestone:  1.10.3
Component:  pgadmin  |     Version:  1.10  
 Keywords:           |    Platform:  all   
---------------------+------------------------------------------------------
 The error log of the database shows that pgAdmin tries to "CREATE OR
 REPLACE FUNCTION" when saving any changes - even if only the comment has
 been modified. The function definition is wrong and triggers an error.

 It looks like both notations "OUT-Parameters" and "RETURNS TABLE" are
 applied. The result is nonsense like this:

 CREATE OR REPLACE FUNCTION foo(IN integer, TABLE a text, TABLE b text,
 TABLE c text) RETURNS SETOF TABLE(a text, b text, c text) AS ...

--
Ticket URL: <http://code.pgadmin.org/trac/ticket/188>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III