Happens on:
PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.96
PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.96
-- Pgsql inserts bad timestamp (seconds 60.00):
CREATE TABLE datetest ( datecol timestamp );
INSERT INTO datetest VALUES ('2002-01-05 09:23:59.999');
SELECT * from datetest;
DROP TABLE datetest;
datecol
---------------------------
2002-01-05 09:23:60.00-05
(1 row)
-->> 23 minutes 60 seconds <<--
-- When the database backup is created and restored back into psql,
-- the error 'bad external timestamp representation'
-- occures and pgsql refuses to insert all data into particular table.
-- Workaround: (before backup)
-- UPDATE datetest SET datecol = datecol - '00:00:00.01'::time WHERE date_part('second',datecol)
> 59.99;
