Re: Add support for AT LOCAL

Thomas Munro <thomas.munro@gmail.com>

From: Thomas Munro <thomas.munro@gmail.com>

To: Michael Paquier <michael@paquier.xyz>

Cc: Tom Lane <tgl@sss.pgh.pa.us>, Vik Fearing <vik@postgresfriends.org>, cary huang <hcary328@gmail.com>, pgsql-hackers@lists.postgresql.org

Date: 2023-10-16T02:53:56Z

Lists: pgsql-hackers

On Mon, Oct 16, 2023 at 2:58 PM Michael Paquier <michael@paquier.xyz> wrote:
> Another theory would be one of these weird compiler optimization issue
> from xlc?  In recent history, there was 8d2a01ae12cd.

Yeah, there are more like that too.  xlc 12.1 is dead (like the OS
version it shipped with).  New versions are available on cfarm if we
care about this target.  But I am conscious of the cosmic law that if
you blame the compiler too soon you can cause the bug to move into
your code...

Commits

Dodge a compiler bug affecting timetz_zone/timetz_izone.
- f4f55d5124a9 13.13 landed
- e98f47d570a2 11.22 landed
- d8c2877b9efa 12.17 landed
- 85c9dda81887 14.10 landed
- 5463319acd19 15.5 landed
- 1ad3a7bd396a 16.1 landed
- 19fa977311b9 17.0 landed
Back-patch test cases for timetz_zone/timetz_izone.
- fdf8b70a51cf 13.13 landed
- dc159b95d921 14.10 landed
- b18781c2df44 12.17 landed
- 4a427b82cf19 16.1 landed
- 29231dbd40cb 15.5 landed
- 05b4614decac 11.22 landed
Add regression test coverage for timetz_izone().
- 2f047203074c 17.0 landed
Add support for AT LOCAL
- 97957fdbaa42 17.0 landed
doc: Mention timezone(zone, time) in section for AT TIME ZONE
- 7e1f544827ec 17.0 landed
Use HASH_BLOBS for xidhash.
- a1b8aa1e4eec 14.0 cited