Postgres Pro
Downloads
Home   >   mailing lists

RE: Stored function | Grayed out option when I try modify the return type - Mailing list pgsql-general

From Abelardo León González
Subject RE: Stored function | Grayed out option when I try modify the return type
Date
Msg-id 013a01d419be$32c61530$98523f90$@abelardolg.com
Whole thread Raw
In response to Re: Stored function | Grayed out option when I try modify the returntype  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Responses Re: Stored function | Grayed out option when I try modify the returntype  (Andreas Kretschmer <andreas@a-kretschmer.de>)
List pgsql-general
Tree view 
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@a-kretschmer.de>
Enviado el: jueves, 12 de julio de 2018 10:53
Para: pgsql-general@lists.postgresql.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

pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Stored function | Grayed out option when I try modify the returntype
Next
From: Andreas Kretschmer
Date:
Subject: Re: Stored function | Grayed out option when I try modify the returntype