Re: backend closing connections while executing...

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Anand Raman <araman(at)india-today(dot)com>
Cc: postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: backend closing connections while executing...
Date: 2001-01-26 00:49:36
Message-ID: Pine.LNX.3.96.1010126014437.475A-100000@ara.zf.jcu.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Thu, 25 Jan 2001, Anand Raman wrote:

> hi guys
>
> While executing a simple query my the psql session reports that the
> session has closed abnormally..
>
> Can any one point out why .. The sample sql query is as follows..
>
> Also when i do a query as simple as
> arttoday=# select ltrim(to_char(exh_dist.length,'9999D99')) from exhibit_distributions exh_dist
> the backend closes abnormally..
>

It can be a to_char() problem. Can you send "crash" query directly with
data? What go into function to_char()? (select exh_dist.length from
exh_dist).

PG version? Are you use locales?

Karel

In response to

Browse pgsql-general by date

  From Date Subject
Next Message adb 2001-01-26 00:51:37 how do I test conditions inside a stored procedure/function
Previous Message Valter Mazzola 2001-01-26 00:40:05 Re: Connection pooling