Thread

to_char() causes backend to close connection

Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu> — 2000-12-14T11:44:47Z

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