On Tue, Dec 10, 2013 at 8:26 AM, Peter Kroon <plakroon@xxxxxxxxx> wrote: > 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? nope! Changing input or output arguments what identifies a function basically as in any overloaded language. Imagine if you had inlined that function call into a view. How would that view be adjusted? The way to deal with this, as in many things with postgres or database in general, is to get *out* of the habit of using UI tools to manage schema structures and get in the habit of maintaining proper schema scripts, particularly for views in functions. This makes DROP a non issue: after CASCADE eats your various views or whatever, you then just have to reapply your view containing script. merlin merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
