Postgres Pro
Downloads
Home   >   mailing lists

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

From Dave Page
Subject Re: Pgadmin III not honoring DATESTYLE
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E40103D8CD@ratbert.vale-housing.co.uk
Whole thread Raw
In response to Pgadmin III not honoring DATESTYLE  (Francisco Leovey <fleovey@yahoo.com>)
Responses Re: Pgadmin III not honoring DATESTYLE
List pgadmin-support
Tree view
 

From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-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

pgadmin-support by date:

Previous
From: Francisco Leovey
Date:
Subject: Pgadmin III not honoring DATESTYLE
Next
From: Jim Cripe
Date:
Subject: pgAdmin on SUSE 10.0 needing libcrypto.so.5 and libssl.so.5