Received: from Stimpy.netroedge.com (IDENT:phil@Stimpy.netroedge.com [206.58.104.66]) by hub.org (8.10.1/8.10.1) with ESMTP id e7AGAeG90189 for ; Thu, 10 Aug 2000 12:10:40 -0400 (EDT) Received: (from phil@localhost) by Stimpy.netroedge.com (8.9.1a/8.9.1) id JAA01996; Thu, 10 Aug 2000 09:12:04 -0700 Date: Thu, 10 Aug 2000 09:12:04 -0700 From: phil@Stimpy.netroedge.com To: =?iso-8859-1?Q?Rolf_L=FCttecke?= Cc: pgsql-interfaces@postgresql.org Subject: Re: Backend-Crash Message-ID: <20000810091204.E26552@Stimpy.netroedge.com> References: <39927D7C.6E0DFAD0@michael-telecom.de> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit User-Agent: Mutt/1.2.4i In-Reply-To: <39927D7C.6E0DFAD0@michael-telecom.de>; from rolf.luettecke@michael-telecom.de on Thu, Aug 10, 2000 at 12:01:32PM +0200 X-Archive-Number: 200008/73 Anything logged? What are the switches you used to start the backend with? Does the Perl 'Pg' interface do the same thing? Still need more info to really give an intelligent possible reason. Good luck! Phil On Thu, Aug 10, 2000 at 12:01:32PM +0200, Rolf Lüttecke wrote: > Hi all, > > the following query, used in a perl-script, kills the backend - > but works when offered through "psql": > > $query = "SELECT count(bk_vk_dem), to_char(sum(bk_vk_dem),'999999D00') > FROM ccbooked > WHERE bk_kartentyp = " . $kartenid[$i]; > > > My configuration: > - DBI-1.13 > - DBD-Pg-0.93 > - SuSE-Linux 2.2.14 > - PostgreSQL 7.0.2 > - gcc 2.95.2 > > Any clou? > > Thanx in advance > -Rolf -- Philip Edelbrock -- IS Manager -- Edge Design, Corvallis, OR phil@netroedge.com -- http://www.netroedge.com/~phil PGP F16: 01 D2 FD 01 B5 46 F4 F0 3A 8B 9D 7E 14 7F FB 7A