Re: Pgadmin III not honoring DATESTYLE - Mailing list pgadmin-support

From Andreas Pflug
Subject Re: Pgadmin III not honoring DATESTYLE
Date
Msg-id 43D0E17F.6070607@pse-consulting.de
Whole thread Raw
In response to Re: Pgadmin III not honoring DATESTYLE  ("Dave Page" <dpage@vale-housing.co.uk>)
List pgadmin-support
Dave Page wrote:
>  
> 
>     ------------------------------------------------------------------------
>     *From:* Francisco Leovey [mailto:fleovey@yahoo.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


pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Pgadmin III not honoring DATESTYLE
Next
From: "Dave Page"
Date:
Subject: Re: Pgadmin III not honoring DATESTYLE