to_char() causes backend to close connection

From: Kovacs Zoltan Sandor <tip(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu>
To: pgsql-bugs(at)postgresql(dot)org
Subject: to_char() causes backend to close connection
Date: 2000-12-14 11:44:47
Message-ID: Pine.LNX.4.05.10012141235440.8309-100000@pc10.radnoti-szeged.sulinet.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruno Wolff III 2000-12-14 16:50:48 grant oddity
Previous Message Gena Gurchonok 2000-12-14 07:15:45 Windows ODBC tables list (with 7.1 CVS)