Re: plperl & sort - Mailing list pgsql-bugs

From Alex Hunsaker
Subject Re: plperl & sort
Date
Msg-id 34d269d40811051037x71a43353s46d16e49e00ef99e@mail.gmail.com
Whole thread Raw
In response to Re: plperl & sort  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: plperl & sort  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
List pgsql-bugs
On Wed, Nov 5, 2008 at 11:14, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Andrew Gierth <andrew@tao11.riddles.org.uk> writes:
>> Nice theory, but completely wrong: sort creates $a and $b in the
>> current package, not in main::.
>
> Hmm ... so then why are we seeing a failure?

Because Safe runs in a different namespace altogether (part of why its
Safe).  We build the sub under Safe but then execute it  in the real
namespace.   The patch I posted fixes this but Id like someone with
more knowledge of safe to look over it.  From a quick cvs log it
*looked* like that was Andrew Dunstan which is why I cc'ed him.  This
is not a Safe bug IMHO its our (ab)use of it that is causing the
problem.  Of course if its only sort that gets affected maybe the cure
is worse than the disease...

pgsql-bugs by date:

Previous
From: "Alex Hunsaker"
Date:
Subject: Re: plperl & sort
Next
From: Kev
Date:
Subject: Re: BUG #4509: array_cat's null behaviour is inconsistent