Re: Problem migrating dump to latest CVS snapshot.

Gunnar R|nning <gunnar@candleweb.no>

From: Gunnar R|nning <gunnar@candleweb.no>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-general@postgresql.org
Date: 2001-03-23T02:07:16Z
Lists: pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:

> 
> If you still have the value stored in the original database, please try
> 	select date_part('seconds', ...)
> to see what that reports as the true seconds part of the value.
> 

Seems you hit the nail with your theory :

sf-ng=# select date_part('seconds', a_accesstime) from access_log where
a_accesstime > '2000-10-24 15:14:59' limit 1;
 date_part
-----------
    59.997
(1 row)

sf-ng=#


regards, 

	Gunnar