| From: | Petr Jelinek <petr(at)2ndquadrant(dot)com> |
|---|---|
| To: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Noah Misch <noah(at)leadboat(dot)com> |
| Cc: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, Steve Singer <steve(at)ssinger(dot)info>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Andres Freund <andres(at)2ndquadrant(dot)com>, Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com>, Anssi K??ri?inen <anssi(dot)kaariainen(at)thl(dot)fi>, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Jaime Casanova <jaime(at)2ndquadrant(dot)com> |
| Subject: | Re: tracking commit timestamps |
| Date: | 2014-12-15 08:41:36 |
| Message-ID: | 548E9EC0.4080001@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers Postg스포츠 토토SQL : Postg스포츠 토토SQL 메일 링리스트 : 2014-12-15 이후 PGSQL WWW 08:41 |
On 15/12/14 09:12, Michael Paquier wrote:
> On Wed, Dec 10, 2014 at 6:50 PM, Noah Misch <noah(at)leadboat(dot)com> wrote:
>> On Mon, Dec 08, 2014 at 02:23:39AM +0100, Petr Jelinek wrote:
>>> On 08/12/14 00:56, Noah Misch wrote:
>>>> The commit_ts test suite gives me the attached diff on a 32-bit MinGW build
>>>> running on 64-bit Windows Server 2003. I have not checked other Windows
>>>> configurations; the suite does pass on GNU/Linux.
>>>
>>> Hmm I wonder if "< now()" needs to be changed to "<= now()" in those queries
>>> to make them work correctly on that plarform, I don't have machine with that
>>> environment handy right now, so I would appreciate if you could try that, in
>>> case you don't have time for that, I will try to setup something later...
>>
>> I will try that, though perhaps not until next week.
>
> FWIW, I just tried that with MinGW-32 and I can see the error on Win7.
> I also checked that changing "< now()" to "<= now()" fixed the
> problem, so your assumption was right, Petr.
> Regards,
>
Cool, thanks, I think it was the time granularity problem in Windows.
--
Petr Jelinek http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kyotaro HORIGUCHI | 2014-12-15 09:09:44 | Async execution of postgres_fdw. |
| Previous Message | Shigeru Hanada | 2014-12-15 08:40:18 | Re: Join push-down support for foreign tables |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Noah Misch | 2014-12-16 02:07:12 | Re: tracking commit timestamps |
| Previous Message | Michael Paquier | 2014-12-15 08:12:10 | Re: tracking commit timestamps |