Thread: [pgAdmin III] #191: Functions returning TABLE lose necessary double quotes for names
[pgAdmin III] #191: Functions returning TABLE lose necessary double quotes for names
From
"pgAdmin Trac"
Date:
#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
Re: [pgAdmin III] #191: Functions returning TABLE lose necessary double quotes for names
From
"pgAdmin Trac"
Date:
#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
Re: [pgAdmin III] #191: Functions returning TABLE lose necessary double quotes for names
From
"pgAdmin Trac"
Date:
#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