Radoslaw Zielinski <[EMAIL PROTECTED]> writes: > I'm building beta2 --with-system-tzdata, my /usr/share/zoneinfo/posixrules > is a symbolic link to localtime, which is Europe/London; the horology test > fails in three places: > ... > If .../posixrules is a symlink to America/New_York (as originally in > tzdata) or does not exist at all, the test passes. Question: what is > broken here? Postgres, my setup, the concept behind posixrules...?
I think nothing is broken: the regression tests are detecting that there's something unexpected about the behavior of your platform, which is what they're supposed to do. The particular tests in question are run with SET TIME ZONE 'CST7CDT', and since that's not a recognized time zone name (CST6CDT is...), it's interpreted as using posixrules. In general, --with-system-tzdata is going to expose you to behavioral differences compared to a standard Postgres installation. There's nothing we can or want to do about that. An interesting question here is whether the use of 'CST7CDT' was a typo or an intentional invocation of an unknown POSIX-spec timezone setting. I suspect it was a typo, because it was added here: http://archives.postgresql.org/pgsql-committers/2005-07/msg00650.php and there's nothing to suggest that Michael was thinking specifically of POSIX-style timezones. However, I think it's probably good that that corner case is getting tested, so I'm inclined to leave it alone (but maybe add a comment pointing out what is happening). OTOH, maybe that is more platform dependence than we want? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
