summaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2023-09-29 20:20:57 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2023-09-29 20:20:57 -0400
commitfd6a06fccb65ea864ae9886305dcc9b4d81052db (patch)
tree3e7ff6c5f83ffc1cfa400f0dd78ad9fadbd665d4 /src
parente9d1560d3e4d01c2aef176340b2d3f93d884922b (diff)
Remove environment sensitivity in pl/tcl regression test.
Add "-gmt 1" to our test invocations of the Tcl "clock" command, so that they do not consult the timezone environment. While it doesn't really matter which timezone is used here, it does matter that the command not fall over entirely. We've now discovered that at least on FreeBSD, "clock scan" will fail if /etc/localtime is missing. It seems worth making the test insensitive to that. Per Tomas Vondras' buildfarm animal dikkop. Thanks to Thomas Munro for the diagnosis. Discussion: https://postgr.es/m/316d304a-1dcd-cea1-3d6c-27f794727a06@enterprisedb.com
Diffstat (limited to 'src')
-rw-r--r--src/pl/tcl/expected/pltcl_setup.out2
-rw-r--r--src/pl/tcl/sql/pltcl_setup.sql2
2 files changed, 2 insertions, 2 deletions
diff --git a/src/pl/tcl/expected/pltcl_setup.out b/src/pl/tcl/expected/pltcl_setup.out
index ed809f02bfb..a8fdcf31256 100644
--- a/src/pl/tcl/expected/pltcl_setup.out
+++ b/src/pl/tcl/expected/pltcl_setup.out
@@ -119,7 +119,7 @@ CREATE OPERATOR CLASS tcl_int4_ops
-- for initialization problems.
--
create function tcl_date_week(int4,int4,int4) returns text as $$
- return [clock format [clock scan "$2/$3/$1"] -format "%U"]
+ return [clock format [clock scan "$2/$3/$1" -gmt 1] -format "%U" -gmt 1]
$$ language pltcl immutable;
select tcl_date_week(2010,1,26);
tcl_date_week
diff --git a/src/pl/tcl/sql/pltcl_setup.sql b/src/pl/tcl/sql/pltcl_setup.sql
index e9f59989b5b..b9892ea4f76 100644
--- a/src/pl/tcl/sql/pltcl_setup.sql
+++ b/src/pl/tcl/sql/pltcl_setup.sql
@@ -142,7 +142,7 @@ CREATE OPERATOR CLASS tcl_int4_ops
-- for initialization problems.
--
create function tcl_date_week(int4,int4,int4) returns text as $$
- return [clock format [clock scan "$2/$3/$1"] -format "%U"]
+ return [clock format [clock scan "$2/$3/$1" -gmt 1] -format "%U" -gmt 1]
$$ language pltcl immutable;
select tcl_date_week(2010,1,26);