Le lundi 7 septembre 2009 à 08:26:27, Rakotomandimby Mihamina a écrit : > [...] > 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? >
You're probably looking for CREATE OR REPLACE. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
