Re: Pgadmin III not honoring DATESTYLE

Dave Page wrote:
>
>
> ------------------------------------------------------------------------
> *From:* Francisco Leovey [mailto:fleovey(at)yahoo(dot)com]
> *Sent:* 20 January 2006 12:14
> *To:* Dave Page
> *Subject:* Re: [pgadmin-support] Pgadmin III not honoring DATESTYLE
>
> Hello Dave
>
> I understand your answer, bu if you check in PgAdmin II this works
> fine, so it is an unexpected change. I beleive PgAdmin III should
> inquire from the server the setting of DATESTYLE and use it, just as
> before.
> Thanks and best regards
>
>
> Hi Francisco,
>
> pgAdmin II is a totally different codebase, which we learned a lot from.
> One of those things was that having differing datestyles can lead to
> confusion and accidental data corruption (if you've ever had to try to
> fix the dates in a multi-million row table you'll know where I'm coming
> from). As I said in an earlier email, if someone want's to write a patch
> that makes honouring DATESTYLE a non-default option, then we'll
> certainly consider including it, however this is not something I intend
> to work on.

Changing DATESTYLE is NOT acceptable, like we don't have an encoding
option. Both ENCODING and DATESTYLE are options that are selected to
guarantee a _machine_ readable format. I won't allow this to be mixed
with GUI representation.
However, it would be possible (actually: still planned) to have the
_display_ dependent on locale settings, including usage of a date entry
control.

Regards,
Andreas