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

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jan Wieck <janwieck@yahoo.com>
Cc: jm.poure@freesurf.fr, Andrew Sullivan <andrew@libertyrms.info>, PostgreSQL general list <pgsql-general@postgresql.org>, pgsql-hackers@postgresql.org
Date: 2002-02-11T20:02:38Z
Lists: pgsql-hackers
Jan Wieck <janwieck@yahoo.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