| 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: | Whole Thread | Raw Message | 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
| 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 |
| 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 |