Skip site navigation (1) Skip section navigation (2)

7.1: to_char() bug fix

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: pgsql-patches <pgsql-patches(at)postgreSQL(dot)org>
Subject: 7.1: to_char() bug fix
Date: 2000-12-14 14:39:23
Message-ID: Pine.LNX.3.96.1001214152701.13007C-101000@ara.zf.jcu.cz (view raw or flat)
Thread:
Lists: pgsql-patches

 Hi,

 here is a patch fixing today's bug report:

> Date: Thu, 14 Dec 2000 12:44:47 +0100 (CET)
> From: Kovacs Zoltan Sandor <tip(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu>
> To: pgsql-bugs(at)postgresql(dot)org
> Subject: [BUGS] 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)

 Again thanks Kovacs, you found really designing bug, that appear
if anyone write bad format template to "number" version of to_char()
(as you with 'DD').

					Karel

PS. It's not recursive diff, must be apply into src/utils/atd, Thanks.

Attachment: to_char-12142000.patch.gz
Description: application/x-gzip (1.6 KB)

Responses

pgsql-patches by date

Next:From: Adam LangDate: 2000-12-14 16:02:43
Subject: Re: more odbc patches
Previous:From: Adam LangDate: 2000-12-14 14:15:16
Subject: Re: more odbc patches

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group