Skip site navigation (1) Skip section navigation (2)

BUG

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 (view raw or flat)
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


pgadmin-support by date

Next:From: Dave PageDate: 2003-04-22 18:15:58
Subject: Re: BUG
Previous:From: Julie MayDate: 2003-04-21 21:39:57
Subject: large object oid value not showing up in pgAdmin

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group