Re: Question about function body checking and 8.1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
Cc: tony_caduto(at)amsoftwaredesign(dot)com, Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Question about function body checking and 8.1
Date: 2005-03-23 16:59:09
Message-ID: 7685.1111597149@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sean Davis <sdavis2(at)mail(dot)nih(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2005-03-23 16:59:57 Re: Command Prompt on Window version
Previous Message A. Mous 2005-03-23 16:56:33 Re: Simple query takes a long time on win2K