Another problem with reverse engineering functions - Mailing list pgadmin-support

From Kieran McCusker
Subject Another problem with reverse engineering functions
Date
Msg-id 4BBC4697.3060307@kwest.info
Whole thread Raw
Responses Re: Another problem with reverse engineering functions  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgadmin-support
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






pgadmin-support by date:

Previous
From: "Garbin, David"
Date:
Subject: GSSAPI Support under OSX
Next
From: Olivier Bouiron
Date:
Subject: pgpass