Excerpts from pratikchirania's message of mar sep 27 08:22:45 -0300 2011:
> Hi,
>
> Thanks for the replies and confirmation.
> Can you provide me with any defect number or some equivalent for tracking
> purpose?
Hmm, this was fixed in the master Git branch (what's going to become 9.2
eventually)
Hi,
Thanks for the replies and confirmation.
Can you provide me with any defect number or some equivalent for tracking
purpose?
Regards, Pratik
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Timezone-issues-with-Postgres-tp4809498p4844991.html
Sent from the PostgreSQL
Magnus Hagander writes:
> On Thu, Sep 22, 2011 at 07:42, Tom Lane wrote:
>> I think we ought to map "Central America Standard Time" to plain CST6.
>>
>> Magnus, AFAICT from the commit logs, that lookup table was your work to
>> begin with --- do you remember anything about the reasoning for the
>
On Thu, Sep 22, 2011 at 07:42, Tom Lane wrote:
> pratikchirania writes:
>> 1. I am in Costa Rica, using Windows Server 2008 R2/Windows 2003 with
>> PostgreSQL 8.3/9.0
>> 2. System Date/Time Settings shows "CST/Central America" with UTC-6 as extra
>> display
>> 4. There is NO DST for CST (Central
pratikchirania writes:
> 1. I am in Costa Rica, using Windows Server 2008 R2/Windows 2003 with
> PostgreSQL 8.3/9.0
> 2. System Date/Time Settings shows "CST/Central America" with UTC-6 as extra
> display
> 4. There is NO DST for CST (Central America) a.k.a America/Costa_Rica to the
> PostgreSQL d
Hi, thanks for the responses. Here are updates from my end:
1. I am in Costa Rica, using Windows Server 2008 R2/Windows 2003 with
PostgreSQL 8.3/9.0
2. System Date/Time Settings shows "CST/Central America" with UTC-6 as extra
display
system timezone: (using command: systeminfo)
Time Zone:
Euler Taveira de Oliveira writes:
> On 21-09-2011 13:38, Robert Haas wrote:
>> The rules for interpreting time zone specifications are arcane enough
>> to make me suspect that this isn't a bug even though it seems rather
>> odd, but in any case it would be useful to know how many hours
>> PostgreS
On 21-09-2011 13:38, Robert Haas wrote:
On Wed, Sep 21, 2011 at 3:16 AM, pratikchirania wrote:
The command clearly does not return '--with-system-tzdata'. I am using
Windows server 2008 R2. The TZ data must be working fine as other
applications on the OS are working fine. The issue is also repr
On Wed, Sep 21, 2011 at 3:16 AM, pratikchirania wrote:
> The command clearly does not return '--with-system-tzdata'. I am using
> Windows server 2008 R2. The TZ data must be working fine as other
> applications on the OS are working fine. The issue is also reproducible on
> Postgre version 8.3.
Y
Hi,
Thanks for your response.
I tried your suggestion and got the following outputs:
C:\PostgreSQL\9.0\bin>pg_config
BINDIR = C:/POSTGR~1/9.0/bin
DOCDIR = C:/POSTGR~1/9.0/doc
HTMLDIR = C:/POSTGR~1/9.0/doc
INCLUDEDIR = C:/POSTGR~1/9.0/include
PKGINCLUDEDIR = C:/POSTGR~1/9.0/include
INCLUDEDIR-SERV
On 16-09-2011 01:57, pratikchirania wrote:
Time is being interpreted incorrectly when I set time zone to UTC -6
(Central America).
Time shown when I query "SELECT NOW()" is 1 hour ahead of system time.
PS: Central america does not have daylight saving. That might not be the
issue.
It is not a bu
Hi,
I am experiencing the following anomaly while using postgres database:
Time is being interpreted incorrectly when I set time zone to UTC -6
(Central America).
Time shown when I query "SELECT NOW()" is 1 hour ahead of system time.
PS: Central america does not have daylight saving. That might no
12 matches
Mail list logo
