From: | Radoslaw Stachowiak <radek(at)alter(dot)pl> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | strange behaviour of gettimeofday() and pg_dump |
Date: | 2001-11-06 17:57:05 |
Message-ID: | 20011106185705.Q7681@blue.alter.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Intro data:
1. table with one (from many) columns:
timestamp | timestamp with time zone | not null default timeofday()
used because I need better time resultion than just second provided by
use of now().
2. pg_dump database > file
now, in such file, there are somtimes (it depends on specific data)
entries like this (only this column): 07:32:60 <- 60 seconds!
and such dump is useless for 'cat file|pgsql database' beacuse psql
refuses such entries.
Looks like that one of them (pg_dump or psql) should be fixed to match
the other. Please look, that column has strict type (timestamp with time zone)
this is postgresql 7.1.3 speaking ;-)
any help/info appreciated.
so far, I just correct this errors by hand before loading db (which
occurs very seldom). BTW, Ive seen entries like: 6:59:60, which are hard
to automated, because the change touches even an hour.
--
radoslaw.stachowiak.........................................http://alter.pl/
From | Date | Subject | |
---|---|---|---|
Next Message | Manuel Duran Aguete | 2001-11-06 23:01:50 | Perfomance problems |
Previous Message | Stephan Szabo | 2001-11-06 17:07:09 | Re: Perfomance problems |