Re: [GENERAL] ALTER FUNCTION

UPDATE pg_proc SET prosrc='SQL statement' WHERE proname LIKE
'functionname';

seems to work for SQL queries at least. I doubt it's recommended,
though!

Moray

----------------------------------------------------------------------
----------------
Moray(dot)McConnachie(at)computing-services(dot)oxford(dot)ac(dot)uk
----- Original Message -----
From: Sascha Ziemann <szi(at)khs-ag(dot)de>
To: <pgsql-general(at)postgreSQL(dot)org>
Sent: Thursday, December 02, 1999 11:39 AM
Subject: [GENERAL] ALTER FUNCTION

> Hi,
>
> are there plans for an ALTER FUNCTION statement for Postgresql? I
> think functions are completely unuseable, when it is not possible to
> change the definition of a function. A bugfix in a function
requires
> the export of all data, a redefinition of the function and a
complete
> reimport. Or is there a simpler way?
>
> Sascha
>
> ************
>
>