updating a function - Mailing list pgsql-admin

From Chris Ruprecht
Subject updating a function
Date
Msg-id 002c01c13584$1654dca0$5dd26383@corp.compucom.com
Whole thread Raw
List pgsql-admin
Hi all,
 
not sure, if this belongs into this list or in the SQL list, but, here goes:
 
I changed a function (some business rules changed). I did the writing of the code in one terminal window and I had another terminal window open, running in psql.
after I saved the file to disk (vi :w command :), I did an \i function-name.sql in the psql window.
It did the DROP/CREATE thing just as expected, but when I then ran the function (select function-name();), it was still running the OLD version.
After I did a \q and back into psql cycle and re-ran the function, it used the new version.
 
It seems to have something to do with caching. Can anybody tell me which parameter to switch on or off to prevent this behavior?
 
Best regards,
Chris
 

pgsql-admin by date:

Previous
From: "Hartwig Jens"
Date:
Subject: Book "PostgreSQL" to be released in November 2001
Next
From: "Taher H. Haveliwala"
Date:
Subject: using multiple partitions for a single table