Re: backend closing connections while executing... - Mailing list 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