strange behaviour of gettimeofday() and pg_dump

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/

Browse pgsql-admin by date

  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