Re: pl/perl interpreter instance(s) - how long does it persist? - Mailing list pgsql-general

From Tom Lane
Subject Re: pl/perl interpreter instance(s) - how long does it persist?
Date
Msg-id 26684.1291862250@sss.pgh.pa.us
Whole thread Raw
In response to pl/perl interpreter instance(s) - how long does it persist?  (Toby Corkindale <toby.corkindale@strategicdata.com.au>)
Responses Re: pl/perl interpreter instance(s) - how long does it persist?  (Toby Corkindale <toby.corkindale@strategicdata.com.au>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Toby Corkindale
Date:
Subject: Re: pl/perl object destruction (or lack thereof) at session end
Next
From: Toby Corkindale
Date:
Subject: Re: pl/perl interpreter instance(s) - how long does it persist?