Re: Syntax error in plpgsql crashes backend

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Roberto Mello <rmello(at)cc(dot)usu(dot)edu>
Cc: Joseph Barillari <jbarilla(at)princeton(dot)edu>, pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Syntax error in plpgsql crashes backend
Date: 2002-06-03 04:00:12
Message-ID: 200206030400.g5340Cl08766@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message russm 2002-06-03 06:45:36 Re: alternate idioms for large "IN (...)" lists
Previous Message Paul 2002-06-03 00:53:47 to_date()