Re: Syntax error in plpgsql crashes backend

IIRC, a gentleman whose name escapes me fixed this in CVS -- the problem 
was that the PL/pgsql handler wasn't grabbing enough memory. The 
current devel sources should reflect the fix. --Joe


On Mon, 3 Jun 2002, Bruce Momjian wrote:

> 
> I just tried this on current sources and it was fine:
> 
> test=> select version();
>                             version                             
> ----------------------------------------------------------------
>  PostgreSQL 7.3devel on i386-pc-bsdi4.2, compiled by GCC 2.95.2
> (1 row)
> 
> 
> ---------------------------------------------------------------------------
> 
> Roberto Mello wrote:
> > On Sat, May 04, 2002 at 02:19:35PM -0400, Joseph Barillari wrote:
> > > More fun with the backend: I've found that I can incite a crash by
> > > reloading a long, but syntactically correct function twice. Is this a
> > > problem with my installation? --Joe
> > 
> > <snip>
> > 
> > I created Joseph's function here and the my backend also crashes.
> > 
> > foobar=# select version();
> >                             version                            
> > ---------------------------------------------------------------
> >  PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.95.4
> > 
> > -Roberto
> > 
> > -- 
> > +----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+
> >   Roberto Mello - Computer Science, USU - http://www.brasileiro.net/ 
> >        http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer    
> > Homework time limit exceeded.  Auto logon in effect!
> > 
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> > 
> > http://www.postgresql.org/users-lounge/docs/faq.html
> > 
> 
> -- 
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
>