RE: Stored function | Grayed out option when I try modify the return type

From: Abelardo León González <everis(at)abelardolg(dot)com>
To: "'Andreas Kretschmer'" <andreas(at)a-kretschmer(dot)de>, <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: RE: Stored function | Grayed out option when I try modify the return type
Date: 2018-07-12 08:56:15
Message-ID: 013a01d419be$32c61530$98523f90$@abelardolg.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks Andreas for your response.

This is an annoying procedure to modify it.
Why did pgAdmin staff decide to do it this way? It's a waste time!

:/

Best regards.

-----Mensaje original-----
De: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
Enviado el: jueves, 12 de julio de 2018 10:53
Para: pgsql-general(at)lists(dot)postgresql(dot)org
Asunto: Re: Stored function | Grayed out option when I try modify the return
type

Am 12.07.2018 um 10:25 schrieb Abelardo León González:
>
> Hello world,
>
> Here a newbie in PgAdmin.
>
> When I create a stored function and I try to modify it to change the
> return type (or anything else), I can’t modify it.
>
> I am not sure if it is a bug….and I am not sure if this message should
> be in bugs mail list. Sorry if I am wrong.
>

it's not a bug. If you want to change the return-type or input-parameters
you have to recreate (drop the current one and create a
new) the function - or to create a new (additional) one.

Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2018-07-12 09:07:13 Re: Stored function | Grayed out option when I try modify the return type
Previous Message Andreas Kretschmer 2018-07-12 08:52:50 Re: Stored function | Grayed out option when I try modify the return type