What changed?

System Catalogs · PostgreSQL 11 → 12

Historical documentation for a PostgreSQL version that is no longer supported.

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

--- 11
+++ 12
@@ -2,4 +2,3 @@
 adrelid  oid
 adnum  int2
 adbin  pg_node_tree
-adsrc  text

changedpg_attribute

--- 11
+++ 12
@@ -14,6 +14,7 @@
 atthasdef  bool
 atthasmissing  bool
 attidentity  char
+attgenerated  char
 attisdropped  bool
 attislocal  bool
 attinhcount  int4

changedpg_class

--- 11
+++ 12
@@ -17,7 +17,6 @@
 relkind  char
 relnatts  int2
 relchecks  int2
-relhasoids  bool
 relhasrules  bool
 relhastriggers  bool
 relhassubclass  bool

changedpg_collation

--- 11
+++ 12
@@ -3,6 +3,7 @@
 collnamespace  oid
 collowner  oid
 collprovider  char
+collisdeterministic  bool
 collencoding  int4
 collcollate  name
 collctype  name

changedpg_constraint

--- 11
+++ 12
@@ -23,4 +23,3 @@
 conffeqop  oid[]
 conexclop  oid[]
 conbin  pg_node_tree
-consrc  text

changedpg_proc

--- 11
+++ 12
@@ -6,7 +6,7 @@
 procost  float4
 prorows  float4
 provariadic  oid
-protransform  regproc
+prosupport  regproc
 prokind  char
 prosecdef  bool
 proleakproof  bool

changedpg_shadow

--- 11
+++ 12
@@ -5,5 +5,5 @@
 userepl  bool
 usebypassrls  bool
 passwd  text
-valuntil  abstime
+valuntil  timestamptz
 useconfig  text[]

changedpg_stat_database

--- 11
+++ 12
@@ -14,6 +14,8 @@
 temp_files  bigint
 temp_bytes  bigint
 deadlocks  bigint
+checksum_failures  bigint
+checksum_last_failure  timestamp with time zone
 blk_read_time  double precision
 blk_write_time  double precision
 stats_reset  timestamp with time zone

addedpg_stat_gssapi

--- 11
+++ 12
@@ -0,0 +1,4 @@
+pid  integer
+gss_authenticated  boolean
+principal  text
+encrypted  boolean

addedpg_stat_progress_cluster

--- 11
+++ 12
@@ -0,0 +1,12 @@
+pid  integer
+datid  oid
+datname  name
+relid  oid
+command  text
+phase  text
+cluster_index_relid  oid
+heap_tuples_scanned  bigint
+heap_tuples_written  bigint
+heap_blks_total  bigint
+heap_blks_scanned  bigint
+index_rebuild_count  bigint

addedpg_stat_progress_create_index

--- 11
+++ 12
@@ -0,0 +1,16 @@
+pid  integer
+datid  oid
+datname  name
+relid  oid
+index_relid  oid
+command  text
+phase  text
+lockers_total  bigint
+lockers_done  bigint
+current_locker_pid  bigint
+blocks_total  bigint
+blocks_done  bigint
+tuples_total  bigint
+tuples_done  bigint
+partitions_total  bigint
+partitions_done  bigint

changedpg_stat_replication

--- 11
+++ 12
@@ -17,3 +17,4 @@
 replay_lag  interval
 sync_priority  integer
 sync_state  text
+reply_time  timestamp with time zone

changedpg_stat_ssl

--- 11
+++ 12
@@ -4,4 +4,6 @@
 cipher  text
 bits  integer
 compression  boolean
-clientdn  text
+client_dn  text
+client_serial  numeric
+issuer_dn  text

changedpg_statistic

--- 11
+++ 12
@@ -14,6 +14,11 @@
 staop3  oid
 staop4  oid
 staop5  oid
+stacoll1  oid
+stacoll2  oid
+stacoll3  oid
+stacoll4  oid
+stacoll5  oid
 stanumbers1  float4[]
 stanumbers2  float4[]
 stanumbers3  float4[]

changedpg_statistic_ext

--- 11
+++ 12
@@ -4,5 +4,3 @@
 stxowner  oid
 stxkeys  int2vector
 stxkind  char[]
-stxndistinct  pg_ndistinct
-stxdependencies  pg_dependencies

addedpg_statistic_ext_data

--- 11
+++ 12
@@ -0,0 +1,4 @@
+stxoid  oid
+stxdndistinct  pg_ndistinct
+stxddependencies  pg_dependencies
+stxdmcv  pg_mcv_list

addedpg_stats_ext

--- 11
+++ 12
@@ -0,0 +1,13 @@
+schemaname  name
+tablename  name
+statistics_schemaname  name
+statistics_name  name
+statistics_owner  oid
+attnames  name[]
+kinds  text[]
+n_distinct  pg_ndistinct
+dependencies  pg_dependencies
+most_common_vals  anyarray
+most_common_val_nulls  anyarray
+most_common_freqs  real[]
+most_common_base_freqs  real[]

changedpg_user

--- 11
+++ 12
@@ -5,5 +5,5 @@
 userepl  bool
 usebypassrls  bool
 passwd  text
-valuntil  abstime
+valuntil  timestamptz
 useconfig  text[]