Postgres Pro
Downloads
Home   >   mailing lists

Re: Stored function | Grayed out option when I try modify the returntype - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: Stored function | Grayed out option when I try modify the returntype
Date
Msg-id b3060f89-69da-5815-6fe7-d4e771a5f69b@a-kretschmer.de
Whole thread Raw
In response to Stored function | Grayed out option when I try modify the return type  (Abelardo León González <everis@abelardolg.com>)
Responses RE: Stored function | Grayed out option when I try modify the return type  (Abelardo León González <everis@abelardolg.com>)
List pgsql-general
Tree view 

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: Guillaume Lelarge
Date:
Subject: Re: How to watch for schema changes
Next
From: Abelardo León González
Date:
Subject: RE: Stored function | Grayed out option when I try modify the return type