From c66f9f0ae5e6d2899b7a6a5f46e30e95c08850a1 Mon Sep 17 00:00:00 2001 From: Christoph Berg Date: Fri, 4 Oct 2024 17:27:20 +0200 Subject: [PATCH] Set timezone to UTC Make us independent from changes to pg_regress' hard-coded Pacific time zone. --- expected/datatypes.out | 5 +++-- expected/datatypes_3.out | 5 +++-- sql/datatypes.sql | 1 + 3 files changed, 7 insertions(+), 4 deletions(-) diff --git a/expected/datatypes.out b/expected/datatypes.out index a13c19e..ff40415 100644 --- a/expected/datatypes.out +++ b/expected/datatypes.out @@ -711,6 +711,7 @@ COPY: \N -- ---------------------------------------------------------------------------------------------- -- +set timezone = 'Etc/UTC'; create table timestamptz (x timestamptz); insert into timestamptz values ('2000-01-01 00:00'), ('100-01-01 BC 2:22'), ('infinity'), ('-infinity'), (null); \set relname timestamptz @@ -744,9 +745,9 @@ Block 0 ******************************************************** ----- Item 1 -- Length: 32 Offset: 8160 (0x1fe0) Flags: NORMAL -COPY: 2000-01-01 08:00:00.000000+00 +COPY: 2000-01-01 00:00:00.000000+00 Item 2 -- Length: 32 Offset: 8128 (0x1fc0) Flags: NORMAL -COPY: 0100-01-01 10:22:00.000000+00 BC +COPY: 0100-01-01 02:22:00.000000+00 BC Item 3 -- Length: 32 Offset: 8096 (0x1fa0) Flags: NORMAL COPY: infinity Item 4 -- Length: 32 Offset: 8064 (0x1f80) Flags: NORMAL diff --git a/expected/datatypes_3.out b/expected/datatypes_3.out index beaedba..f7ea25f 100644 --- a/expected/datatypes_3.out +++ b/expected/datatypes_3.out @@ -711,6 +711,7 @@ COPY: \N -- ---------------------------------------------------------------------------------------------- -- +set timezone = 'Etc/UTC'; create table timestamptz (x timestamptz); insert into timestamptz values ('2000-01-01 00:00'), ('100-01-01 BC 2:22'), ('infinity'), ('-infinity'), (null); \set relname timestamptz @@ -744,9 +745,9 @@ Block 0 ******************************************************** ----- Item 1 -- Length: 32 Offset: 8160 (0x1fe0) Flags: NORMAL -COPY: 2000-01-01 08:00:00.000000+00 +COPY: 2000-01-01 00:00:00.000000+00 Item 2 -- Length: 32 Offset: 8128 (0x1fc0) Flags: NORMAL -COPY: 0100-01-01 10:22:00.000000+00 BC +COPY: 0100-01-01 02:22:00.000000+00 BC Item 3 -- Length: 32 Offset: 8096 (0x1fa0) Flags: NORMAL COPY: infinity Item 4 -- Length: 32 Offset: 8064 (0x1f80) Flags: NORMAL diff --git a/sql/datatypes.sql b/sql/datatypes.sql index da2a0dc..e1a7703 100644 --- a/sql/datatypes.sql +++ b/sql/datatypes.sql @@ -84,6 +84,7 @@ insert into timestamp values ('2000-01-01 00:00'), ('100-01-01 BC 2:22'), ('infi \set relname timestamp \ir run_test.sql +set timezone = 'Etc/UTC'; create table timestamptz (x timestamptz); insert into timestamptz values ('2000-01-01 00:00'), ('100-01-01 BC 2:22'), ('infinity'), ('-infinity'), (null); \set relname timestamptz -- 2.39.5