-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Tom,
This is what I have in '/usr/share/pgsql/timezonesets/Atlantic.txt':
WEST 3600 D # Western Europe Summer Time
# (Atlantic/Canary)
# (Atlantic/Faeroe)
# (Atlantic/Madeira)
# (Europe/Lisbon)
I copied this portion into '/usr/share/pgsql/timezonesets/Default' and
restarted the service.
Still no go :(
I even tried alter user user-slony set timezone='WEST';
After the mods this what the query gives:
ERROR: unrecognized time zone name: "WEST"
And this is when I ran out of ideas...
btw: do you happen to know of a Slony mailing list?
TIA,
Pedro Doria Meunier
GSM: +351 96 17 20 188
Skype: pdoriam
Tom Lane wrote:
> Pedro Doria Meunier <pdoria@xxxxxxxxxxxxxx> 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
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org
iD8DBQFKSOBE2FH5GXCfxAsRAr+8AJsHvnlpWWZw7rVb2Kp9A70Q4/DJPwCfXbrb
L+n1Km17aMA7AzhUe7IqvPs=
=THOj
-----END PGP SIGNATURE-----
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
