Re: [BUGS] Recovery bug

2010-10-17 Thread Jeff Davis
On Fri, 2010-10-15 at 15:58 -0700, Jeff Davis wrote: > I don't have a fix yet, because I think it requires a little discussion. > For instance, it seems to be dangerous to assume that we're starting up > from a backup with access to the archive when it might have been a crash > of the primary syste

Re: [BUGS] BUG #5714: TZ pattern error on to_timestamp

2010-10-17 Thread Tom Lane
hubert depesz lubaczewski writes: > On Sun, Oct 17, 2010 at 11:10:09AM -0400, Tom Lane wrote: >> Testing shows that that example fails in every Postgres release back to >> 7.1. The spelling of the error message varies a bit, but they all agree >> that a TZ format spec isn't supported. > Any reas

Re: [BUGS] BUG #5714: TZ pattern error on to_timestamp

2010-10-17 Thread hubert depesz lubaczewski
On Sun, Oct 17, 2010 at 11:10:09AM -0400, Tom Lane wrote: > "Alexander Loechel" writes: > > After an update on my ubuntu system of postgres 8.4.4 to 8.4.5 the > > to_timestamp methode produces different results. > > > in a CREAT View statement I have following methode call: > > to_timestamp(dbtim

Re: [BUGS] BUG #5714: TZ pattern error on to_timestamp

2010-10-17 Thread Tom Lane
"Alexander Loechel" writes: > After an update on my ubuntu system of postgres 8.4.4 to 8.4.5 the > to_timestamp methode produces different results. > in a CREAT View statement I have following methode call: > to_timestamp(dbtimestamp, '/MM/DD HH24:MI:SS TZ') AS "timestamp"<< > Where dbtimest

[BUGS] BUG #5714: TZ pattern error on to_timestamp

2010-10-17 Thread Alexander Loechel
The following bug has been logged online: Bug reference: 5714 Logged by: Alexander Loechel Email address: alexander.loec...@unibw.de PostgreSQL version: 8.4.5 Operating system: Ubuntu Server 10.04. LTS Description:TZ pattern error on to_timestamp Details: After an u