Thread: Backend-Crash

Backend-Crash

From
Rolf Lüttecke
Date:
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


Re: Backend-Crash

From
phil@Stimpy.netroedge.com
Date:
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/~philPGP
F16:01 D2 FD 01 B5 46 F4 F0  3A 8B 9D 7E 14 7F FB 7A