Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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.


pgsql-admin by date

Next:From: Manuel Duran AgueteDate: 2001-11-06 23:01:50
Subject: Perfomance problems
Previous:From: Stephan SzaboDate: 2001-11-06 17:07:09
Subject: Re: Perfomance problems

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group