postgres
diff --git a/‎src/backend/utils/adt/pg_locale.c
Copy file name to clipboardExpand all lines: src/backend/utils/adt/pg_locale.c
+12-2Lines changed: 12 additions & 2 deletions b/‎src/backend/utils/adt/pg_locale.c
Copy file name to clipboardExpand all lines: src/backend/utils/adt/pg_locale.c
+12-2Lines changed: 12 additions & 2 deletions
diff --git a/‎src/include/catalog/catversion.h
Copy file name to clipboardExpand all lines: src/include/catalog/catversion.h
+1-1Lines changed: 1 addition & 1 deletion b/‎src/include/catalog/catversion.h
Copy file name to clipboardExpand all lines: src/include/catalog/catversion.h
+1-1Lines changed: 1 addition & 1 deletion
diff --git a/‎src/include/catalog/pg_collation.dat
Copy file name to clipboardExpand all lines: src/include/catalog/pg_collation.dat
+2-2Lines changed: 2 additions & 2 deletions b/‎src/include/catalog/pg_collation.dat
Copy file name to clipboardExpand all lines: src/include/catalog/pg_collation.dat
+2-2Lines changed: 2 additions & 2 deletions
@@ -1732,13 +1732,23 @@ get_collation_actual_version(char collprovider, const char *collcollate)
 
 	/*
 	 * The only two supported locales (C and C.UTF-8) are both based on memcmp
-	 * and are not expected to change.
+	 * and are not expected to change, but track the version anyway.
 	 *
 	 * Note that the character semantics may change for some locales, but the
 	 * collation version only tracks changes to sort order.
 	 */
 	if (collprovider == COLLPROVIDER_BUILTIN)
-		return NULL;
+	{
+		if (strcmp(collcollate, "C") == 0)
+			return "1";
+		else if (strcmp(collcollate, "C.UTF-8") == 0)
+			return "1";
+		else
+			ereport(ERROR,
+					(errcode(ERRCODE_WRONG_OBJECT_TYPE),
+					 errmsg("invalid locale name \"%s\" for builtin provider",
+							collcollate)));
+	}
 
 #ifdef USE_ICU
 	if (collprovider == COLLPROVIDER_ICU)
 
@@ -57,6 +57,6 @@
  */
 
 /*							yyyymmddN */
-#define CATALOG_VERSION_NO	202403272
+#define CATALOG_VERSION_NO	202403291
 
 #endif
@@ -25,13 +25,13 @@
   collcollate => 'POSIX', collctype => 'POSIX' },
 { oid => '962', descr => 'sorts by Unicode code point, C character semantics',
   collname => 'ucs_basic', collprovider => 'b', collencoding => '6',
-  colllocale => 'C' },
+  colllocale => 'C', collversion => '1' },
 { oid => '963',
   descr => 'sorts using the Unicode Collation Algorithm with default settings',
   collname => 'unicode', collprovider => 'i', collencoding => '-1',
   colllocale => 'und' },
 { oid => '811', descr => 'sorts by Unicode code point; Unicode and POSIX character semantics',
   collname => 'pg_c_utf8', collprovider => 'b', collencoding => '6',
-  colllocale => 'C.UTF-8' },
+  colllocale => 'C.UTF-8', collversion => '1' },
 
 ]