[ python-Bugs-1000588 ] Function is not replaced

noreply at pgfoundry.org noreply at pgfoundry.org
Thu Mar 16 22:53:42 GMT 2006


Bugs item #1000588, was opened at 2006-03-15 10:32
You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=442&aid=1000588&group_id=1000094

Category: BE/TEOP
>Group: To do
Status: Open
>Resolution: Accepted
>Priority: 1
Submitted By: Adrian Klaver (aklaver)
Assigned to: James Pye (jwp)
Summary: Function is not replaced

Initial Comment:
When you use CREATE OR REPLACE FUNCTION and make a change to the function the change is not reflected until you log out of a session and then log back in.

----------------------------------------------------------------------

>Comment By: James Pye (jwp)
Date: 2006-03-16 15:53

Message:
Yes, the function cache will hold the function until the end of the session or until replacement within the *same* session. Right now, I think I should probably clear the function cache at the end of transactions. For the time being, just try to recreate the function in the same session that you are testing things in. I think psql can do this with \i

Sorry for any inconvenience.

----------------------------------------------------------------------

You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=442&aid=1000588&group_id=1000094


More information about the Python-general mailing list