Re: Bug #630: date/time storage problem: timestamp parsed

Поиск
Список
Период
Сортировка
От Michael Loftis
Тема Re: Bug #630: date/time storage problem: timestamp parsed
Дата
Msg-id 3CBA8134.5070407@wgops.com
обсуждение исходный текст
Ответ на Re: Bug #630: date/time storage problem: timestamp parsed  (Thomas Lockhart <lockhart@fourpalms.org>)
Ответы Re: Bug #630: date/time storage problem: timestamp parsed  (Sean Chittenden <sean@chittenden.org>)
Список pgsql-bugs
Cuttign down the CC: list this time, apologies if I cut too much and
someone misses a copy of this....

Sean Chittenden wrote:

>
>The FreeBSD folk are absolutely adamant about having mktime() no
>compensate for deadzones between DST shifts and they insist that the
>application handle this.  Someone's off looking at how other OS'es
>handle this, but this could be an arduous battle on that front.  <:~)
>
Personally I'd like to see FreeBSD do away with this strange behaviour.
 It cause my grief because certaint hings *MUST* be done at 0200 every
day in our system, I was forced to do them manually recently, shifing
several hours of work into daytime which had to be paused and bulked
into the next days work.  I realise that this is getting off track but
it just points out that the FreeBSD behaviour is IMHO WRONG.  It causes
applications to fail in an unexpected and odd way.

I'm not objecting to pg patching for it (no choice at the moment) but I
hope the pg team 'officially' puts a little pressure on the BSD folk to
make this behave as expected.

I don't have any compliance docs at the moment, but this strikes me as
somewhat out of spec personally.

>>I know the attached patch is something of a hack, but it works.  I'm
>>not totally wild about altering the original time object, but I
>>don't know that I have a choice in this case.  Does anyone switch
>>timezones and only adjust their clocks by anything other than 60min?
>>I seem to recall that happening in a few places, but the patch isn't
>>any worse than where we are now. ::shrug:: This look like an okay
>>patch?
>>
>
>Are there any objections to the following?  Instead of returning 0 or
>utc, I could have it raise an error.  Would that be acceptable?  -sc
>

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Bug #597: ResultSet.next() throws NullPointerException
Следующее
От: Sean Chittenden
Дата:
Сообщение: Re: Bug #630: date/time storage problem: timestamp parsed