Re: Problem migrating dump to latest CVS snapshot. - Mailing list pgsql-general

From Gunnar R|nning
Subject Re: Problem migrating dump to latest CVS snapshot.
Date
Msg-id x67l1h9r1n.fsf@thor.candleweb.no
Whole thread Raw
In response to Problem migrating dump to latest CVS snapshot.  (Gunnar R|nning <gunnar@candleweb.no>)
Responses Re: Problem migrating dump to latest CVS snapshot.
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] SPI example does not work for 7.1beta4
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Foreign keys/unique values and views