| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | Rakotomandimby Mihamina <mihamina(at)gulfsat(dot)mg> |
| Subject: | Re: edit function |
| Date: | 2009-09-07 06:31:05 |
| Message-ID: | 200909070831.05206.guillaume@lelarge.info |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ow Mun Heng | 2009-09-07 07:38:33 | trigger and returning the #of rows affected (partitioning) |
| Previous Message | Rakotomandimby Mihamina | 2009-09-07 06:26:27 | edit function |