From: | "Mendola Gaetano" <mendola(at)bigfoot(dot)com> |
---|---|
To: | <pgadmin-support(at)postgresql(dot)org> |
Subject: | BUG |
Date: | 2003-04-22 13:29:41 |
Message-ID: | 005b01c308d3$3b28b0f0$152aa8c0@GMENDOLA2 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hi all,
I'm using pgAdmin 1.4.12 and Postgres 7.3.2
I create a function that return a SETOF:
CREATE OR REPLACE FUNCTION foo ( )
RETURNS SETOF public.foo_type AS'
DECLARE
BEGIN
RETURN ;
END;
' LANGUAGE 'plpgsql';
if I try to edit this function inside pgAdmin the redefinition
fail, pgAdmin try to recreate this function in the following way:
CREATE OR REPLACE FUNCTION public.foo( )
RETURNS public.foo_type AS '
DECLARE
BEGIN
RETURN ;
END;
' LANGUAGE 'plpgsql';
the SETOF is not there anymore
and correctly postgres say that the new definition change
the return type.
Gaetano
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2003-04-22 18:15:58 | Re: BUG |
Previous Message | Julie May | 2003-04-21 21:39:57 | large object oid value not showing up in pgAdmin |