invalid timestamp with 7.1

From: Michael Adler <adler(at)glimpser(dot)org>
To: pgsql-cygwin(at)postgresql(dot)org
Subject: invalid timestamp with 7.1
Date: 2002-05-30 04:07:01
Message-ID: Pine.NEB.4.44.0205291331570.3679-100000@reva.sixgirls.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin


I've been getting several ERRORs "bad timestamp external representation",
and these are timestamps generated internally with "DEFAULT
CURRENT_TIMESTAMP". About 1 in 3,000 rows has been assigned timestamp
values with "60" for the seconds field (e.g. 14:37:60). When I try to
copy these values to other tables, I get an exception.

It is possible that newer version have fixed this. Has anyone seen this?

Thanks,

Mike Adler

In response to

Browse pgsql-cygwin by date

  From Date Subject
Next Message anji 2002-05-31 14:22:31 Please help me ERROR: pq_recvbuf: recv() failed: The descriptor is a file, not a socket
Previous Message Jason Tishler 2002-05-29 11:21:23 Re: how to access the archives