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