Re: Slony-I timezone setting

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Pedro Doria Meunier <pdoria(at)netmadeira(dot)com>
Cc: Postgresql Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Slony-I timezone setting
Date: 2009-06-29 15:04:45
Message-ID: 12609.1246287885@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Pedro Doria Meunier <pdoria(at)netmadeira(dot)com> writes:
> This is what's defined in postgresql.conf

> datestyle = 'iso, ymd'
> timezone = 'Atlantic/Madeira'

Hmm. WET/WEST are the zone abbreviations for that zone, all right,
but I don't understand why they're being emitted if you have that
datestyle setting. Maybe something is overriding the datestyle for
some dumb reason?

Anyway, a look at the default timezone abbrevs file shows that it
recognizes WETDST not WEST. You might care to add WEST as an
accepted abbrev too.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lennin Caro 2009-06-29 15:21:43 Re: Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql function
Previous Message Merlin Moncure 2009-06-29 15:00:36 Re: [PERFORM] Terrible Write Performance of a Stored Procedure