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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
>