On Sep 7, 2009, at 2:26 AM, Rakotomandimby Mihamina wrote:
I have a function like this:
CREATE FUNCTION f_active_client(character varying)
RETURNS character varying
AS $_$
DECLARE
v_modem ALIAS FOR $1;
v_firstuse BOOLEAN;
v_admactive BOOLEAN;
v_codeclt varchar;
BEGIN
SELECT INTO (...)
IF FOUND THEN
(...)
ELSE
RETURN 'ERROR';
END IF;
END;
$_$
I have to insert several IF statements in the "IF FOUND" one.
I wont do it one time, I will insert them one by one.
I cannot stop too much long the PG server (a /etc/init.d restart
time is OK, more is not)
Dumping and the restoring is not possible because of too long
downtime.
DELETing CREATing the function is not possible because of dependency.
When looking at the help, '\h' has no REPLACE FUNCTION.
Only ALTER FUNCTION
How to manage it?
Write it exactly as you have above, but replace the first line with:
CREATE OR REPLACE FUNCTION f_active_client(character varying)
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
