Postgres Pro
Downloads
Home   >   mailing lists

Re: Interesting date/time 60 second problem with Postgresql - Mailing list pgsql-admin

From Tom Lane
Subject Re: Interesting date/time 60 second problem with Postgresql
Date
Msg-id 9346.1035239986@sss.pgh.pa.us
Whole thread Raw
In response to Interesting date/time 60 second problem with Postgresql  (Will LaShell <will@lashell.net>)
List pgsql-admin
Tree view 
Will LaShell <will@lashell.net> writes:
> psql:/mnt/nfs/sql/replication_test.sql:603812: ERROR:  copy: line 44060,
> Bad timestamp external representation '2002-10-07 09:55:60.00-07'

> I know there were time accuracy fixes put in, was this something that
> was fixed?

Yeah, this is an old bug.  You'll need to use sed or something to find
and fix the dump lines containing '60.00'.

            regards, tom lane

pgsql-admin by date:

Previous
From: Will LaShell
Date:
Subject: Interesting date/time 60 second problem with Postgresql
Next
From: Casey Allen Shobe
Date:
Subject: Cannot reference system table