Tom,
many thanks. Perfect advice as usual...
Corrected version attached for the archives.
Kuba
Tom Lane napsal(a):
Kuba Ouhrabka <[EMAIL PROTECTED]> writes:
IF Var_datos.pronargs > 0 THEN
Var_args := '';
FOR i IN 0..Var_datos.pronargs-1 LOOP
> [howto recreate plpgsql functions]
Start here:
http://archives.postgresql.org/pgsql-hackers/2005-09/msg00690.php
Great, thanks!
I slighltly modified the function - it was not working for overloaded
functions (same name, different arguments) and for functions with named
arguments. Modified
Hi,
is there an easy way to flush all cached query plans in pl/pgsql
functions? I've long running sessions where data are changing and the
plans become inaccurate after a while. I can imagine something like
recreating all pl/pgsql functions. I can recreate them from sql source
files but I'd p
