Обсуждение: [pgAdmin III] #191: Functions returning TABLE lose necessary double quotes for names

#191: Functions returning TABLE lose necessary double quotes for names
---------------------+------------------------------------------------------
 Reporter:  brsa     |       Owner:  dpage 
     Type:  bug      |      Status:  new   
 Priority:  minor    |   Milestone:  1.10.4
Component:  pgadmin  |     Version:        
 Keywords:           |    Platform:  all   
---------------------+------------------------------------------------------
 Yet another hickup in the reverse engineering of functions returning
 TABLE(): necessary double quotes for field names are lost. The resulting
 SQL DDL is not valid.

 Demo:
 ~~~~~
 -- I say:
 CREATE FUNCTION foo()
   RETURNS TABLE("my id" integer, "soMe TeXt" text) AS  -- note the quotes!
 $$
 SELECT 1, 'two'::text
 $$
   LANGUAGE sql;

 -- pgAdmin says:
 CREATE OR REPLACE FUNCTION foo()
   RETURNS TABLE(my id integer, soMe TeXt text) AS
 $BODY$
 SELECT 1, 'two'::text
 $BODY$
   LANGUAGE 'sql' VOLATILE
   COST 100
   ROWS 1000;
 ALTER FUNCTION foo() OWNER TO postgres;

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

#191: Functions returning TABLE lose necessary double quotes for names
---------------------+------------------------------------------------------
 Reporter:  brsa     |       Owner:  gleu    
     Type:  bug      |      Status:  assigned
 Priority:  minor    |   Milestone:  1.10.4  
Component:  pgadmin  |     Version:  1.10    
 Keywords:           |    Platform:  all     
---------------------+------------------------------------------------------
Changes (by gleu):

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


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

#191: Functions returning TABLE lose necessary double quotes for names
----------------------+-----------------------------------------------------
  Reporter:  brsa     |       Owner:  gleu  
      Type:  bug      |      Status:  closed
  Priority:  minor    |   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 r8427 and r8428.

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