[pgadmin-support] Another problem with reverse engineering functions

[Kieran McCusker]

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





--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support