Re: Problem migrating dump to latest CVS snapshot.

From: Gunnar R|nning <gunnar(at)candleweb(dot)no>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem migrating dump to latest CVS snapshot.
Date: 2001-03-23 02:07:16
Message-ID: x67l1h9r1n.fsf@thor.candleweb.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-03-23 02:07:25 Re: [HACKERS] SPI example does not work for 7.1beta4
Previous Message Limin Liu 2001-03-23 02:00:10 Re: [HACKERS] SPI example does not work for 7.1beta4

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-03-23 02:07:25 Re: [HACKERS] SPI example does not work for 7.1beta4
Previous Message Limin Liu 2001-03-23 02:00:10 Re: [HACKERS] SPI example does not work for 7.1beta4