Re: More Time Zone fun

Just to further note an oddity, apparently PostgreSQL in fact *does*
support leap seconds since 7.4 After scouring the manual for info on
this, I discovered on this page:

http://www.postgresql.org/docs/8.2/static/release-7-4.html

Tom added support for 60 second values in the seconds component of
TIME/TIMESTAMP/INTERVAL data types, which, as noted by the changelog, is
needed for support of leap seconds. So this error very well may be a
behavioral bug. Should I post this to -hackers or -bugs ?
- Naz.

Naz Gassiep wrote:
> I'm making (slow) progress in my timezone system, and I just noticed
> this little behavioral nugget, which surely is a bug. In the system
> view pg_timezone_names is a few timezones that use leap seconds. An
> example which I tested is Asia/Riyadh87. When I attempt to SET TIME
> ZONE using this timezone, I get this:
>
> ERROR: time zone "Asia/Riyadh87" appears to use leap seconds DETAIL:
> PostgreSQL does not support leap seconds.
>
> Surely it's a bug to have timezones in the list that result in errors
> being thrown? Also, is there a reason that PostgreSQL does not support
> leap seconds?
> Regards,
> - Naz
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>       choose an index scan if your joining column's datatypes do not
>       match
>