Dave Page wrote:
------------------------------------------------------------------------
*From:* Francisco Leovey [mailto:[EMAIL PROTECTED]
*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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster