updating a function

From: "Chris Ruprecht" <chrup999(at)yahoo(dot)com>
To: "pgadmin" <pgsql-admin(at)postgresql(dot)org>
Subject: updating a function
Date: 2001-09-04 20:56:36
Message-ID: 002c01c13584$1654dca0$5dd26383@corp.compucom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-admin by date

  From Date Subject
Next Message Taher H. Haveliwala 2001-09-04 20:58:06 using multiple partitions for a single table
Previous Message Hartwig Jens 2001-09-04 07:25:56 Book "PostgreSQL" to be released in November 2001