This has been saved for the 8.3 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold
--------------------------------------------------------------------------- Tom Lane wrote: > Back when we converted src/timezone to use int64 for pg_time_t, we > wondered what to do about extending the compiled timezone data file > format for int64, so that it would work for years beyound 2038. We > shelved the problem waiting to see what the upstream zic folks would do. > Well, it looks like they've done something about it. So I think we > ought to plan on updating our code to match theirs, so that we fix the > y2038 problem while keeping it possible to use a standard zic-database > installation with Postgres. This is not urgent (I surely see no need > to hold up 8.2 to fix it), but it ought to go on the TODO list. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(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