________________________________

From: pgadmin-support-owner@postgresql.org
[mailtogadmin-support-owner@postgresql.org] On Behalf Of Francisco
Leovey
Sent: 18 January 2006 12:01
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Pgadmin III not honoring DATESTYLE


PostgreSQL version: 8.1.2
Operating system: Linux
Description: Pgadmin III not honoring DATESTYLE
Details:

By default in postgresql.conf the DATESTYLE is set to
"SQL,European" and it works OK except for Pgadmin III.
When you ask for "view data" in Pgadmin III a date field shows
yyyy-mm-dd instead of dd/mm/yyyy
Please tell me how to fix this


pgAdmin works with DATESTYLE=ISO to ensure that dates cannot be
misinterpreted when using servers with different settings. Supporting
differing datestyles on different servers is not easy to do and can lead
to user confusion. As an administration tool we prefer pgAdmin to remain
unambiguous rather than make it easy to unintentionally enter invalid
data, or misinterpret query results.

Regards, Dave

On 1/18/06, Dave Page <dpage@vale-housing.co.uk> wrote:

> By default in postgresql.conf the DATESTYLE is set to "SQL,European" and it
> works OK except for Pgadmin III.
> When you ask for "view data" in Pgadmin III a date field shows yyyy-mm-dd
> instead of dd/mm/yyyy
> Please tell me how to fix this
>
> pgAdmin works with DATESTYLE=ISO to ensure that dates cannot be
> misinterpreted when using servers with different settings. Supporting
> differing datestyles on different servers is not easy to do and can lead to
> user confusion. As an administration tool we prefer pgAdmin to remain
> unambiguous rather than make it easy to unintentionally enter invalid data,
> or misinterpret query results.
>
> Regards, Dave

I Don't think it's a good idea to set it's own Datestyle in pgAdmin.
I work both witg psql and pgAdmin and have "German" datestyle set for database.
It's not very easy to switch my mind between datestyles.
By the way, previous versions of pgadmin (II ?) worked well.

--
Alexey Vorobyevv
[icq #16768917]

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org