Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 14F65475A6E for ; Mon, 3 Jun 2002 07:20:06 -0400 (EDT) Received: from candle.pha.pa.us (216-55-132-35.dsl.san-diego.abac.net [216.55.132.35]) by postgresql.org (Postfix) with ESMTP id 628C6475938 for ; Mon, 3 Jun 2002 07:14:25 -0400 (EDT) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.10.1) id g5340Cl08766; Mon, 3 Jun 2002 00:00:12 -0400 (EDT) From: Bruce Momjian Message-Id: <200206030400.g5340Cl08766@candle.pha.pa.us> Subject: Re: Syntax error in plpgsql crashes backend In-Reply-To: <20020504232620.GB12969@cc.usu.edu> To: Roberto Mello Date: Mon, 3 Jun 2002 00:00:12 -0400 (EDT) Cc: Joseph Barillari , pgsql-sql X-Mailer: ELM [version 2.4ME+ PL97 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200206/10 X-Sequence-Number: 7975 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 > > > > 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