Обсуждение: [pgAdmin III] #188: Properties dialog for functions returning TABLE() broken.

Поиск
Список
Период
Сортировка

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

От
"pgAdmin Trac"
Дата:
#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

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

От
"pgAdmin Trac"
Дата:
#188: Properties dialog for functions returning TABLE() broken.
---------------------+------------------------------------------------------
 Reporter:  brsa     |       Owner:  dpage 
     Type:  bug      |      Status:  new   
 Priority:  major    |   Milestone:  1.10.4
Component:  pgadmin  |     Version:  1.10  
 Keywords:           |    Platform:  all   
---------------------+------------------------------------------------------
Changes (by gleu):

  * milestone:  1.10.3 => 1.10.4


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

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

От
"pgAdmin Trac"
Дата:
#188: Properties dialog for functions returning TABLE() broken.
---------------------+------------------------------------------------------
 Reporter:  brsa     |       Owner:  gleu    
     Type:  bug      |      Status:  assigned
 Priority:  major    |   Milestone:  1.10.4  
Component:  pgadmin  |     Version:  1.10    
 Keywords:           |    Platform:  all     
---------------------+------------------------------------------------------
Changes (by gleu):

  * owner:  dpage => gleu
  * status:  new => assigned


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

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

От
"pgAdmin Trac"
Дата:
#188: Properties dialog for functions returning TABLE() broken.
----------------------+-----------------------------------------------------
  Reporter:  brsa     |       Owner:  gleu  
      Type:  bug      |      Status:  closed
  Priority:  major    |   Milestone:  1.10.4
 Component:  pgadmin  |     Version:  1.10  
Resolution:  fixed    |    Keywords:        
  Platform:  all      |  
----------------------+-----------------------------------------------------
Changes (by gleu):

  * status:  assigned => closed
  * resolution:  => fixed


Comment:

 Fixed in r8378 and r8379.

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