to_char() causes backend to close connection - Mailing list pgsql-sql

From Kovacs Zoltan Sandor
Subject to_char() causes backend to close connection
Date
Msg-id Pine.LNX.4.05.10012141249370.8309-100000@pc10.radnoti-szeged.sulinet.hu
Whole thread Raw
Responses Re: to_char() causes backend to close connection
List pgsql-sql
Hi, this query gives different strange results:

select to_char(now()::abstime,'YYMMDDHH24MI');

I get e.g. a "backend closed the channel unexpectedly..." error with
successful or failed resetting attempt (indeterministic)

or

ERROR:  to_char/to_number(): not unique decimal poit

or

NOTICE:  PortalHeapMemoryFree: 0x0x8201af0 not in alloc set

My machine works with PostgreSQL 7.0.2 + Red Hat 6.1.
Is this fixed in 7.0.3?

TIA, Zoltan




pgsql-sql by date:

Previous
From: Kovacs Zoltan Sandor
Date:
Subject: arrays in PostgreSQL
Next
From: Karel Zak
Date:
Subject: Re: to_char() causes backend to close connection