[kalman]

Suppose that the function (plpgsql) f1 use f2 and I do some modification to f2 how I can avoid to rebuild f1 also ?


Ciao.

[eperich]

if the function f2 doesnot have other arguments then it's no problem
to deop the f2 and create the new one
without creating the f1

[kalman]

Originally posted by eperich
if the function f2 doesnot have other arguments then it's no problem
to deop the f2 and create the new one
without creating the f1

Of course but this is not the case!!!

[eperich]

maybe the problem is
that one must drop the function and
create it new
internally the oid change
I think thats the problem
the core developers are working on a CREATE or REPLACE FUNCTION
But It's planned in the v7.3

[kalman]

Originally posted by eperich
maybe the problem is
that one must drop the function and
create it new
internally the oid change
I think thats the problem
the core developers are working on a CREATE or REPLACE FUNCTION
But It's planned in the v7.3

Ok.
I know that a function is compiled the first time that the function is used, indeed some times if you forget a ";" you obtain a compile error not a create error. Is enough, I think, say to Postgresql: "assume from now that all function are not yet compiled", doesn't exist a way to invalidate
"the flag: already compiled" ?

[eperich]

I don't think so
but these thigns are deeper in the system
I will look in the docs
maybe I find something that could help