From: | Joel Rees <joel(at)alpsgiken(dot)gr(dot)jp> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: A creepy story about dates. How to prevent it? |
Date: | 2003-06-23 06:28:46 |
Message-ID: | 20030623150641.243F.JOEL@alpsgiken.gr.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> Is it
> desiarable to default postgresql.conf datestyle to match the locale?
>
> #
> # Locale settings
> #
> # (initialized by initdb -- may be changed)
> LC_MESSAGES = 'C'
> LC_MONETARY = 'C'
> LC_NUMERIC = 'C'
> LC_TIME = 'C'
Another JPY 2 from the nattou gallery:
Defaulting the datestyle to the locale setting makes sense to me. I
wouldn't want it hardwired to the locale, of course.
I would strongly request having heuristics off in the default settings.
Two conditions I really want on the use of heuristics -- I want the date
itself to include some "fuzzy" flag, and I want some way to reconstruct
the original string. That way, if I want to design an application with
tools for getting operator attention, etc., there are hooks in the data.
But that feels to me like something for the application layer.
--
Joel Rees, programmer, Kansai Systems Group
Altech Corporation (Alpsgiken), Osaka, Japan
http://www.alpsgiken.co.jp
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Meskes | 2003-06-23 06:30:41 | Re: [pgsql-advocacy] MySQL gets $19.5 MM |
Previous Message | Bruce Momjian | 2003-06-23 05:59:04 | Re: Thousands of semops for every i/o |