Re: Timestamp data type problems

From: Olivier PRENANT <ohp(at)pyrenet(dot)fr>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Timestamp data type problems
Date: 2000-05-29 20:45:22
Message-ID: Pine.UW2.4.21.0005292238540.10589-100000@server.pyrenet.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)pyrenet(dot)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(at)pyrenet(dot)fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Antony Sakellariou 2000-05-29 21:00:54 Cursors
Previous Message Mitch Vincent 2000-05-29 19:57:20 Re: Full text indexing preformance! (long)