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

From Kovacs Zoltan Sandor
Subject to_char() causes backend to close connection
Date
Msg-id Pine.LNX.4.05.10012141235440.8309-100000@pc10.radnoti-szeged.sulinet.hu
Whole thread Raw
List pgsql-bugs
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 on an i686.
Is this fixed in 7.0.3? TIA, Zoltan

pgsql-bugs by date:

Previous
From: Bruno Wolff III
Date:
Subject: More on previous bug report
Next
From: "Joel Burton"
Date:
Subject: Re: Windows ODBC tables list (with 7.1 CVS)