to_char() causes backend to close connection

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Karel Zak 2000-12-14 12:49:24 Re: to_char() causes backend to close connection
Previous Message Kovacs Zoltan Sandor 2000-12-14 11:31:25 arrays in PostgreSQL