Re: [HACKERS] regular expressions from hell

> Date: Sun, 31 May 1998 18:56:29 -0700 (PDT)
> From: Brett McCormick <brett@work.chicken.org>
> Sender: owner-pgsql-hackers@hub.org

> Not to mention the fact that if perl (or mod_perl) is already running
> (and you're using a shared libperl), the library is already loaded.

If you're running Apache, mod_perl or not, isn't Posix regex loaded?
(HSREGEX or compatible?)

> On Sun, 31 May 1998, at 17:23:16, Brett McCormick wrote:
> 
> > Unfortunately, there's no other way.  This is mentioned in the
> > perlcall manpage, I beleive.  One method which is ok in my book is to
> > load the shared perl lib once, in one backend, and then it can be
> > shared between all other backends when they need perl regex's.
> > 
> > There is no mechanism for auto-loading the type/func shared libraries
> > on postmaster startup correct?  It happens per backend sessions?  So
> > to do the above you'd have to have one "Dummy" connection which just
> > did a simple regex and then while(1) { sleep(10^32) };
...