Re: Timestamp data type problems - Mailing list pgsql-hackers

From Olivier PRENANT
Subject Re: Timestamp data type problems
Date
Msg-id Pine.UW2.4.21.0005292238540.10589-100000@server.pyrenet.fr
Whole thread Raw
In response to Re: Timestamp data type problems  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Timestamp data type problems  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
I made a patch against 7.0. Do you need it?

Actually it's quite simple and only ocurs and datetime.c.

afterline 2156, I added : *(str + 28 + MAXSTZLEN) = '\0';

and after line 2166, I added : *(str + 25 + MAXTZLEN) = '\0';

It works for me !!

Regards,
On Mon, 29 May 2000, Tom Lane wrote:

> Olivier PRENANT <ohp@pyrenet.fr> writes:
> > pyrenet=# select 'today'::timestamp
> >                  ?column?                  
> > -------------------------------------------
> >  Mon 29 May 00:00:00 2000 MET DST(ÎäÍ^A
> > (1 row)
> 
> > script done on Mon May 29 13:44:30 2000
> 
> > As you can see, there's no \0 after TZ.
> 
> OK, patched for 7.0.1 (I increased MAXTZLEN as well as made the code
> more careful about overrun of the allowed length).
> 
>             regards, tom lane
> 

-- 
Olivier PRENANT             Tel:    +33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou           +33-5-61-50-97-01 (Fax)
31190 AUTERIVE                      +33-6-07-63-80-64 (GSM)
FRANCE                      Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)



pgsql-hackers by date:

Previous
From: Lamar Owen
Date:
Subject: Header File cleanup.
Next
From: Tom Lane
Date:
Subject: Re: Timestamp data type problems