Thread: Another problem with reverse engineering functions
Hi Sorry if this has been raised before but the following function will not be reverse engineered correctly - It will be changed into a setof return which will break anything expecting organisation_id. CREATE OR REPLACE FUNCTION public.t() RETURNS TABLE (organisation_id integer) AS $$ select 27; $$ LANGUAGE 'sql'; In pgAdmin 10.2 it becomes :- CREATE OR REPLACE FUNCTION public.t() RETURNS SETOF integer AS $BODY$ select 27; $BODY$ LANGUAGE 'sql' VOLATILE COST 100 ROWS 1000; Many thanks Kieran
Le 07/04/2010 10:47, Kieran McCusker a écrit : > [...] > Sorry if this has been raised before but the following function will not > be reverse engineered correctly - It will be changed into a setof return > which will break anything expecting organisation_id. > It's already fixed in the SVN version. See http://code.pgadmin.org/trac/ticket/159 for details. It will be available in 1.10.3. Thanks for your report. -- Guillaume.http://www.postgresqlfr.orghttp://dalibo.com