Home > mailing lists

add parameter to existing function - Mailing list pgsql-general

From	Peter Kroon
Subject	add parameter to existing function
Date	December 10, 2013 17:26:32
Msg-id	CAOh+DOm=3yqvi=Hge70b7OeDu=Cf1-NZe6nTVPwDu_8rEPRYSg@mail.gmail.com Whole thread Raw
Responses	Re: add parameter to existing function (Merlin Moncure <mmoncure@gmail.com>)
List	pgsql-general

Hi,

I can use: create or replace function etc....

to alter a function.

However, this will create a new function instead of replacing the old one when adding a parameter.

Is this possible without the use of DROP and CASCADE?

The function that I'm trying to alter is on some tables a default value.

Best,

Peter

From: "Greg Sabino Mullane"
Date: 10 December 2013, 17:00:42
Subject: Re: PG replication across DataCenters (section 25 in the manual)

From: misspaola@tiscali.it
Date: 10 December 2013, 17:53:26
Subject: DB Audit