From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Mendola Gaetano" <mendola(at)bigfoot(dot)com>, <pgadmin-support(at)postgresql(dot)org> |
Cc: | "frank_lupo" <frank_lupo(at)email(dot)it> |
Subject: | Re: BUG |
Date: | 2003-04-22 18:15:58 |
Message-ID: | 03AF4E498C591348A42FC93DEA9661B8259FCE@mail.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hi,
Unfortunately pgAdmin doesn't fully support set returning functions yet
- in fact the latest versions only indicate that a function is an srf,
they are not clev er enough to edit or create them correctly yet.
Hopefully this will be fixed soon.
Frank: Are you interested in looking at this?
Regards, Dave.
> -----Original Message-----
> From: Mendola Gaetano [mailto:mendola(at)bigfoot(dot)com]
> Sent: 22 April 2003 14:30
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] BUG
>
>
> 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
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an
> appropriate subscribe-nomail command to
> majordomo(at)postgresql(dot)org so that your message can get through
> to the mailing list cleanly
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2003-04-22 18:27:10 | Re: large object oid value not showing up in pgAdmin |
Previous Message | Mendola Gaetano | 2003-04-22 13:29:41 | BUG |