Postgres Pro
Downloads
Home   >   mailing lists

invalid timestamp with 7.1 - Mailing list pgsql-cygwin

From Michael Adler
Subject invalid timestamp with 7.1
Date
Msg-id Pine.NEB.4.44.0205291331570.3679-100000@reva.sixgirls.org
Whole thread Raw
In response to cygwin server w/ data on *nix machine?  ("Mr. Wobbet" <wobbet@wobbet.com>)
List pgsql-cygwin
Tree view 
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

pgsql-cygwin by date:

Previous
From: Jason Tishler
Date:
Subject: Re: how to access the archives
Next
From: "anji"
Date:
Subject: Please help me ERROR: pq_recvbuf: recv() failed: The descriptor is a file, not a socket