|
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
|
