Re: Question about function body checking and 8.1 - Mailing list pgsql-general

From Tom Lane
Subject Re: Question about function body checking and 8.1
Date
Msg-id 7685.1111597149@sss.pgh.pa.us
Whole thread Raw
In response to Re: Question about function body checking and 8.1  (Sean Davis <sdavis2@mail.nih.gov>)
List pgsql-general
Sean Davis <sdavis2@mail.nih.gov> writes:
> On Mar 22, 2005, at 10:04 PM, Tony Caduto wrote:
>> Also if you happen to use PLperl or any of the other ones, do they
>> actually do better checking than PLpgsql?   Last time I used a PLperl
>> function it didn't do any checking at creation either.

> I think (from experience rather than knowledge) that that is still the
> case as of 8.0.1.  I know Tom Lane and I had a brief discussion on one
> of the lists on the subject a month or two ago, but I can't seem to
> find the emails.

CVS-tip createlang still thinks that plpgsql is the only standard PL
that has a validator procedure; therefore the others don't do any
checking at CREATE FUNCTION whatsoever.

It would be reasonable for someone to step up and improve this ...

            regards, tom lane

pgsql-general by date:

Previous
From: "A. Mous"
Date:
Subject: Re: Simple query takes a long time on win2K
Next
From: "Magnus Hagander"
Date:
Subject: Re: Command Prompt on Window version