[pgAdmin III] #191: Functions returning TABLE lose necessary double quotes for names - Mailing list pgadmin-hackers

#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