Another problem with reverse engineering functions

Поиск
Список
Период
Сортировка
Искать
От
Kieran McCusker
Тема
Another problem with reverse engineering functions
Дата
Msg-id
4BBC4697.3060307@kwest.info
Список
Дерево обсуждения
Another problem with reverse engineering functions Kieran McCusker <kieran.mccusker@kwest.info>
Re: Another problem with reverse engineering functions Guillaume Lelarge <guillaume@lelarge.info>
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 по дате отправления
От: Garbin, David
Дата:
Сообщение: GSSAPI Support under OSX
От: Olivier Bouiron
Дата:
Сообщение: pgpass
FAQ