Re: BUG #1956: Plpgsql top-level DECLARE does not share scope - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1956: Plpgsql top-level DECLARE does not share scope
Date
Msg-id 22684.1129217815@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #1956: Plpgsql top-level DECLARE does not share scope  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-bugs
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Karl O. Pinc wrote:
>> Fair enough.  At the same time it sure would be nice if
>> plpgsql actually compiled (and parsed SQL) at
>> function definition time, even when the result is thrown away.

> 8.0 has this improvement:

>      * Do minimal syntax checking of PL/pgSQL functions at creation time (Tom)
>        This allows us to catch simple syntax errors sooner.

8.1 does more in that line (thanks to Neil).

            regards, tom lane

pgsql-bugs by date:

Previous
From: Benjamin Reed
Date:
Subject: Re: building Postgresql 7.3.10 on Mac OS X 10.4
Next
From: Tom Lane
Date:
Subject: Re: building Postgresql 7.3.10 on Mac OS X 10.4