Re: Add support for AT LOCAL

From: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: Vik Fearing <vik(at)postgresfriends(dot)org>, cary huang <hcary328(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Add support for AT LOCAL
Date: 2023-10-15 21:16:47
Message-ID: CA+hUKGK=DOC+hE-62FKfZy=Ybt5uLkrg3zCZD-jFykM-iPn8yw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

One of the AIX animals gave a strange result here:

https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=hornet&dt=2023-10-15%2011%3A40%3A01

If you ignore the diffs due to change in column width, the interesting
change seems to be:

- 23:59:00-07 | 06:59:00+00 | 06:59:00+00 | 06:59:00+00
- 23:59:59.99-07 | 06:59:59.99+00 | 06:59:59.99+00 | 06:59:59.99+00
+ 23:59:00-07 | 4294966103:4294967295:00+00 |
4294966103:4294967295:00+00 | 4294966103:4294967295:00+00
+ 23:59:59.99-07 | 4294966103:00:00.01+00 |
4294966103:00:00.01+00 | 4294966103:00:00.01+00

But the other AIX animal 'sungazer' was OK with it. They're both on
the same AIX7.1 host IIRC, both 64 bit builds, but the former is using
xlc and the latter gcc. I don't immediately see what would cause that
underflow on that old compiler but not elsewhere. I have a shell
there (cfarm111) if someone has an idea...

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2023-10-15 21:57:51 Re: Add support for AT LOCAL
Previous Message Peter Geoghegan 2023-10-15 20:54:25 Re: Optimizing "boundary cases" during backward scan B-Tree index descents