Re: [BUGS] Strange time zone +00:53:28

2013-05-10 Thread Karsten Düsterloh
hubert depesz lubaczewski wrote: >> Under Pg 8.3, we used the timestamp >> 0001-01-01 00:00:00+01 >> as an easy-to-remember marker for 'dunno, but predates any usual >> business dates' for fields of type timestamp with time zone. > > Why didn't you use "-infinity" for this? Back when that value

[BUGS] Strange time zone +00:53:28

2013-05-10 Thread Karsten Düsterloh
Hi! Recently, we switched from Pg 8.3 to Pg 9.1, using Pg9's pg_upgrade to migrate our cluster. The cluster itself is running on a Debian 6 machine with timezone Europe/Berlin, which means UTC+02 currently. Under Pg 8.3, we used the timestamp 0001-01-01 00:00:00+01 as an easy-to-remember marker