aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorJohn Naylor <john.naylor@postgresql.org>2021-08-31 14:15:22 -0400
committerJohn Naylor <john.naylor@postgresql.org>2021-08-31 15:19:57 -0400
commit3eda9fc09fd6b9a1aec2d0113c633c69c3214b4d (patch)
tree959de5a870eacbe99cebaf89ca345804f15d4193
parenta20a9f26cefcf4e35ba7bb3d9e8672cb4ce1cf32 (diff)
downloadpostgresql-3eda9fc09fd6b9a1aec2d0113c633c69c3214b4d.tar.gz
postgresql-3eda9fc09fd6b9a1aec2d0113c633c69c3214b4d.zip
Mark the timestamptz variant of date_bin() as stable
Previously, it was immutable by lack of marking. This is not correct, since the time zone could change. Bump catversion Discussion: https://www.postgresql.org/message-id/CAFBsxsG2UHk8mOWL0tca%3D_cg%2B_oA5mVRNLhDF0TBw980iOg5NQ%40mail.gmail.com Backpatch to v14, when this function came in
-rw-r--r--src/include/catalog/catversion.h2
-rw-r--r--src/include/catalog/pg_proc.dat2
2 files changed, 2 insertions, 2 deletions
diff --git a/src/include/catalog/catversion.h b/src/include/catalog/catversion.h
index 0a4f4abdb39..21b6648f5ad 100644
--- a/src/include/catalog/catversion.h
+++ b/src/include/catalog/catversion.h
@@ -53,6 +53,6 @@
*/
/* yyyymmddN */
-#define CATALOG_VERSION_NO 202107181
+#define CATALOG_VERSION_NO 202108311
#endif
diff --git a/src/include/catalog/pg_proc.dat b/src/include/catalog/pg_proc.dat
index 79669bf5a2e..aee037e2143 100644
--- a/src/include/catalog/pg_proc.dat
+++ b/src/include/catalog/pg_proc.dat
@@ -5844,7 +5844,7 @@
proargtypes => 'interval timestamp timestamp', prosrc => 'timestamp_bin' },
{ oid => '6178',
descr => 'bin timestamp with time zone into specified interval',
- proname => 'date_bin', prorettype => 'timestamptz',
+ proname => 'date_bin', provolatile => 's', prorettype => 'timestamptz',
proargtypes => 'interval timestamptz timestamptz',
prosrc => 'timestamptz_bin' },