Обсуждение: to_char() causes backend to close connection
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
On Thu, 14 Dec 2000, Kovacs Zoltan Sandor wrote: > Hi, this query gives different strange results: > > select to_char(now()::abstime,'YYMMDDHH24MI'); the result: ERROR: to_char/to_number(): not unique decimal poit is right, because we have two to_char(): to_char(int, text) to_char(timestamp, text) and for 'now()::abstime' function manager select "number" version instead timestamp. And in "number" version is D as decimal point. > I get e.g. a "backend closed the channel unexpectedly..." error with > successful or failed resetting attempt (indeterministic) Yes this is a bug to_char() ... I fix it today. > My machine works with PostgreSQL 7.0.2 + Red Hat 6.1. > Is this fixed in 7.0.3? A problem (IMHO it's not problem) with 'now()::abstime' is in 7.1 too. But why you not use directly now()? Thanks! Karel
> A problem (IMHO it's not problem) with 'now()::abstime' is in 7.1 too. > But why you not use directly now()? My aim is to get this format for the time '5 minutes ago'. So I need something like select to_char(now()-'5 minutes','YYMMDDHH24MI') but this doesn't work due to the missing type conversion. Any idea? TIA, Zoltan
<p><font size="2">select to_char(now()-'5 minutes'::interval,'YYMMDDHH24MI') seems to work</font><p><font size="2">Ben</font><p><fontsize="2">> -----Original Message-----</font><br /><font size="2">> From: Kovacs Zoltan Sandor[<a href="mailto:tip@pc10.radnoti-szeged.sulinet.hu">mailto:tip@pc10.radnoti-szeged.sulinet.hu</a>]</font><br /><fontsize="2">> Sent: 14 December 2000 15:49</font><br /><font size="2">> To: Karel Zak</font><br /><font size="2">>Cc: pgsql-sql@postgresql.org</font><br /><font size="2">> Subject: Re: [SQL] to_char() causes backend toclose connection</font><br /><font size="2">> </font><br /><font size="2">> </font><br /><font size="2">> > A problem (IMHO it's not problem) with 'now()::abstime' is </font><br /><font size="2">> in 7.1 too. </font><br /><fontsize="2">> > But why you not use directly now()?</font><br /><font size="2">> My aim is to get this formatfor the time '5 minutes ago'. So I need</font><br /><font size="2">> something like</font><br /><font size="2">></font><br /><font size="2">> select to_char(now()-'5 minutes','YYMMDDHH24MI')</font><br /><font size="2">></font><br /><font size="2">> but this doesn't work due to the missing type conversion.</font><br /><fontsize="2">> </font><br /><font size="2">> Any idea? TIA, Zoltan</font><br /><font size="2">> </font>