Re: Slony-I timezone setting - Mailing list pgsql-general

From Tom Lane
Subject Re: Slony-I timezone setting
Date
Msg-id 12609.1246287885@sss.pgh.pa.us
Whole thread Raw
In response to Re: Slony-I timezone setting  (Pedro Doria Meunier <pdoria@netmadeira.com>)
Responses Re: Slony-I timezone setting
List pgsql-general
Pedro Doria Meunier <pdoria@netmadeira.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

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: [PERFORM] Terrible Write Performance of a Stored Procedure
Next
From: Lennin Caro
Date:
Subject: Re: Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql function