Skip site navigation (1) Skip section navigation (2)

Bad timestamp external representation

From: miles <miles(at)faithwestinc(dot)com>
To: sfpug(at)postgresql(dot)org
Subject: Bad timestamp external representation
Date: 2004-01-11 19:37:18
Message-ID: 4001A5EE.6080305@faithwestinc.com (view raw or flat)
Thread:
Lists: sfpug
Hi

were experiencing some problems when restoring certain databases that 
were dumped with pg_dump, where the date inserted using now() has some 
strange rounding applied ... (postgres version is 7.2)

ERROR:  copy: line 2, Bad timestamp external representation '2002-07-31 
24:00:00'

does anyone know a workaround for this issue other than replacing in the 
dump file?

thanks

miles




Responses

sfpug by date

Next:From: Josh BerkusDate: 2004-01-12 17:45:56
Subject: Re: Bad timestamp external representation
Previous:From: Josh BerkusDate: 2004-01-08 18:12:42
Subject: Re: Meetings this month (January)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group