Another problem with reverse engineering functions

From: Kieran McCusker <kieran(dot)mccusker(at)kwest(dot)info>
To: pgadmin-support(at)postgresql(dot)org
Subject: Another problem with reverse engineering functions
Date: 2010-04-07 08:47:19
Message-ID: 4BBC4697.3060307@kwest.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Olivier Bouiron 2010-04-07 14:21:09 pgpass
Previous Message Garbin, David 2010-04-06 14:20:57 GSSAPI Support under OSX