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

[pgAdmin III] #188: Properties dialog for functions returning TABLE() broken.

From: "pgAdmin Trac" <trac(at)code(dot)pgadmin(dot)org>
To:
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: [pgAdmin III] #188: Properties dialog for functions returning TABLE() broken.
Date: 2010-05-14 02:31:12
Message-ID: 045.d0e414f1b1045903d988a068e972f54d@code.pgadmin.org (view raw or flat)
Thread:
Lists: 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

Responses

pgadmin-hackers by date

Next:From: Erwin BrandstetterDate: 2010-05-14 02:35:06
Subject: Bug in 1.10.3: Properties dialog for functions returning TABLE(..) is broken.
Previous:From: Guillaume LelargeDate: 2010-05-13 21:13:15
Subject: Re: Updated Czech translation (www)

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