From: | "Joseph D(dot) Barillari" <jbarilla(at)Princeton(dot)EDU> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | Roberto Mello <rmello(at)cc(dot)usu(dot)edu>, pgsql-sql <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Syntax error in plpgsql crashes backend |
Date: | 2002-06-03 18:02:55 |
Message-ID: | Pine.LNX.4.44.0206031401500.11442-100000@fez.Princeton.EDU |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Marie G. Tuite | 2002-06-03 21:14:03 | passing a list to a function and returning a recordset |
Previous Message | Kaare Rasmussen | 2002-06-03 16:04:56 | Re: to_date() |