Re: PL/Python import _sre module error

Glenn R Williams wrote:
> Hi All,
>
> Does anyone else have a problem with importing the re package
> I am using:
>
> Redhat 9.0
> PostgreSQL 7.3.3
> Python 2.2.2.26
>
> When I create a function:
>
> import re
> o = args[0]
> b = re.match(r"^t.*",o)
> if b:
> return "fits the bill"
> return "failed the test"
>
> PostgreSQL fails, and returns the error message:
>
> exceptions.ImportError: No module named _sre
>
> If I go into python, this is not a problem, so I suppose it is somehow
> due to the restricted execution environment and/or PostgreSQL. But
> that's as far as I get.

Correct. re is not enabled, because you can create arbitrary cpu (and
perhaps also memory) utilization with it. Thus it's unsafe.

> Any suggestions on how to pinpoint the problem? [...]

Fork pl/python and create an unsafe version without any restrictions?
That's what I once did just for fun. I think that'll be necessary
anyway, because with Python >= 2.2.3, rexec and friends are disabled anyway.

-- Gerhard