Thread: 7.1: to_char() bug fix

7.1: to_char() bug fix

From
Karel Zak
Date:

 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@pc10.radnoti-szeged.sulinet.hu>
> To: pgsql-bugs@postgresql.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

Re: 7.1: to_char() bug fix

From
Bruce Momjian
Date:
Thanks.  Applied.


>
>
>  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@pc10.radnoti-szeged.sulinet.hu>
> > To: pgsql-bugs@postgresql.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.
Content-Description:

[ application/x-gzip is not supported, skipping... ]


--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026