#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