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

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: 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:52:50
Message-ID: b3060f89-69da-5815-6fe7-d4e771a5f69b@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 Abelardo León González 2018-07-12 08:56:15 RE: Stored function | Grayed out option when I try modify the return type
Previous Message Guillaume Lelarge 2018-07-12 08:46:48 Re: How to watch for schema changes