What changed?

System Catalogs · PostgreSQL 14 → 15

5 added · 0 removed · 10 changed · 0 coverage changes. These are changes in the pinned reference snapshots.

--- 14
+++ 15
@@ -5,6 +5,7 @@
 collprovider  char
 collisdeterministic  bool
 collencoding  int4
-collcollate  name
-collctype  name
+collcollate  text
+collctype  text
+colliculocale  text
 collversion  text

changedpg_constraint

--- 14
+++ 15
@@ -21,5 +21,6 @@
 conpfeqop  oid[]
 conppeqop  oid[]
 conffeqop  oid[]
+confdelsetcols  int2[]
 conexclop  oid[]
 conbin  pg_node_tree

changedpg_database

--- 14
+++ 15
@@ -2,13 +2,15 @@
 datname  name
 datdba  oid
 encoding  int4
-datcollate  name
-datctype  name
+datlocprovider  char
 datistemplate  bool
 datallowconn  bool
 datconnlimit  int4
-datlastsysoid  oid
 datfrozenxid  xid
 datminmxid  xid
 dattablespace  oid
+datcollate  text
+datctype  text
+daticulocale  text
+datcollversion  text
 datacl  aclitem[]

addedpg_ident_file_mappings

--- 14
+++ 15
@@ -0,0 +1,5 @@
+line_number  int4
+map_name  text
+sys_name  text
+pg_username  text
+error  text

changedpg_index

--- 14
+++ 15
@@ -3,6 +3,7 @@
 indnatts  int2
 indnkeyatts  int2
 indisunique  bool
+indnullsnotdistinct  bool
 indisprimary  bool
 indisexclusion  bool
 indimmediate  bool

addedpg_parameter_acl

--- 14
+++ 15
@@ -0,0 +1,3 @@
+oid  oid
+parname  text
+paracl  aclitem[]

addedpg_publication_namespace

--- 14
+++ 15
@@ -0,0 +1,3 @@
+oid  oid
+pnpubid  oid
+pnnspid  oid

changedpg_publication_rel

--- 14
+++ 15
@@ -1,3 +1,5 @@
 oid  oid
 prpubid  oid
 prrelid  oid
+prqual  pg_node_tree
+prattrs  int2vector

changedpg_publication_tables

--- 14
+++ 15
@@ -1,3 +1,5 @@
 pubname  name
 schemaname  name
 tablename  name
+attnames  name[]
+rowfilter  text

addedpg_stat_recovery_prefetch

--- 14
+++ 15
@@ -0,0 +1,10 @@
+stats_reset  timestamp with time zone
+prefetch  bigint
+hit  bigint
+skip_init  bigint
+skip_new  bigint
+skip_fpw  bigint
+skip_rep  bigint
+wal_distance  int
+block_distance  int
+io_depth  int

addedpg_stat_subscription_stats

--- 14
+++ 15
@@ -0,0 +1,5 @@
+subid  oid
+subname  name
+apply_error_count  bigint
+sync_error_count  bigint
+stats_reset  timestamp with time zone

changedpg_statistic_ext_data

--- 14
+++ 15
@@ -1,4 +1,5 @@
 stxoid  oid
+stxdinherit  bool
 stxdndistinct  pg_ndistinct
 stxddependencies  pg_dependencies
 stxdmcv  pg_mcv_list

changedpg_stats_ext

--- 14
+++ 15
@@ -6,6 +6,7 @@
 attnames  name[]
 exprs  text[]
 kinds  char[]
+inherited  bool
 n_distinct  pg_ndistinct
 dependencies  pg_dependencies
 most_common_vals  text[]

changedpg_stats_ext_exprs

--- 14
+++ 15
@@ -4,6 +4,7 @@
 statistics_name  name
 statistics_owner  name
 expr  text
+inherited  bool
 null_frac  float4
 avg_width  int4
 n_distinct  float4

changedpg_subscription

--- 14
+++ 15
@@ -1,10 +1,13 @@
 oid  oid
 subdbid  oid
+subskiplsn  pg_lsn
 subname  name
 subowner  oid
 subenabled  bool
 subbinary  bool
 substream  bool
+subtwophasestate  char
+subdisableonerr  bool
 subconninfo  text
 subslotname  name
 subsynccommit  text