Re: [HACKERS] Feature enhancement request : use of libgda

Jan Wieck <janwieck(at)yahoo(dot)com> writes:
> Now it might be possible to tell your function handler to
> recompile that function at the next call without changing the
> OID, but how do you tell the function handlers in all the
> other concurrently running backends to do so after finishing
> their current transaction?

This is in fact all dealt with for CREATE OR REPLACE FUNCTION, but
Jan's point holds also for CREATE OR REPLACE other-stuff. The syntax
change alone is the least of one's worries when implementing such
things.

We were foolish enough to accept a patch for CREATE OR REPLACE FUNCTION
that did not deal with propagating the changes, and had to do a lot of
work to clean up after it. We will not be so forgiving next time...

regards, tom lane