Toby Corkindale <toby.corkindale@strategicdata.com.au> writes:
> I would like to know how long the pl/perl interpreter instances persist?
Till end of session.
> Initial testing seems to give me contrary results.
> In some cases, creating a new DB then loading the same module in a new
> stored procedure will get the old version.
> But in some other cases, the new DB will pick up the new version of the
> module.
"Creating a DB" doesn't affect the current session ... where in there
did you reconnect?
regards, tom lane