Re: Interesting date/time 60 second problem with Postgresql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Will LaShell <will(at)lashell(dot)net>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Interesting date/time 60 second problem with Postgresql
Date: 2002-10-21 22:39:46
Message-ID: 9346.1035239986@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Will LaShell <will(at)lashell(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Casey Allen Shobe 2002-10-22 00:50:15 Cannot reference system table
Previous Message Will LaShell 2002-10-21 22:22:33 Interesting date/time 60 second problem with Postgresql