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.McConnachie@computing-services.oxford.ac.uk
----- Original Message -----
From: Sascha Ziemann <szi@khs-ag.de>
To: <pgsql-general@postgreSQL.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
>
> ************
>
>