What changed?

System Catalogs · PostgreSQL 9.6 → 10

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

11 added · 0 removed · 9 changed · 0 coverage changes. These are changes in the pinned reference snapshots.

--- 9.6
+++ 10
@@ -12,6 +12,7 @@
 attalign  char
 attnotnull  bool
 atthasdef  bool
+attidentity  char
 attisdropped  bool
 attislocal  bool
 attinhcount  int4

changedpg_class

--- 9.6
+++ 10
@@ -26,7 +26,9 @@
 relforcerowsecurity  bool
 relispopulated  bool
 relreplident  char
+relispartition  bool
 relfrozenxid  xid
 relminmxid  xid
 relacl  aclitem[]
 reloptions  text[]
+relpartbound  pg_node_tree

changedpg_collation

--- 9.6
+++ 10
@@ -2,6 +2,8 @@
 collname  name
 collnamespace  oid
 collowner  oid
+collprovider  char
 collencoding  int4
 collcollate  name
 collctype  name
+collversion  text

addedpg_hba_file_rules

--- 9.6
+++ 10
@@ -0,0 +1,9 @@
+line_number  integer
+type  text
+database  text[]
+user_name  text[]
+address  text
+netmask  text
+auth_method  text
+options  text[]
+error  text

addedpg_partitioned_table

--- 9.6
+++ 10
@@ -0,0 +1,7 @@
+partrelid  oid
+partstrat  char
+partnatts  int2
+partattrs  int2vector
+partclass  oidvector
+partcollation  oidvector
+partexprs  pg_node_tree

changedpg_policies

--- 9.6
+++ 10
@@ -1,6 +1,7 @@
 schemaname  name
 tablename  name
 policyname  name
+polpermissive  text
 roles  name[]
 cmd  text
 qual  text

changedpg_policy

--- 9.6
+++ 10
@@ -1,6 +1,7 @@
 polname  name
 polrelid  oid
 polcmd  char
+polpermissive  boolean
 polroles  oid[]
 polqual  pg_node_tree
 polwithcheck  pg_node_tree

addedpg_publication

--- 9.6
+++ 10
@@ -0,0 +1,7 @@
+oid  oid
+pubname  name
+pubowner  oid
+puballtables  bool
+pubinsert  bool
+pubupdate  bool
+pubdelete  bool

addedpg_publication_rel

--- 9.6
+++ 10
@@ -0,0 +1,2 @@
+prpubid  oid
+prrelid  oid

addedpg_publication_tables

--- 9.6
+++ 10
@@ -0,0 +1,3 @@
+pubname  name
+schemaname  name
+tablename  name

changedpg_replication_slots

--- 9.6
+++ 10
@@ -3,6 +3,7 @@
 slot_type  text
 datoid  oid
 database  text
+temporary  boolean
 active  boolean
 active_pid  integer
 xmin  xid

addedpg_sequence

--- 9.6
+++ 10
@@ -0,0 +1,8 @@
+seqrelid  oid
+seqtypid  oid
+seqstart  int8
+seqincrement  int8
+seqmax  int8
+seqmin  int8
+seqcache  int8
+seqcycle  bool

addedpg_sequences

--- 9.6
+++ 10
@@ -0,0 +1,11 @@
+schemaname  name
+sequencename  name
+sequenceowner  name
+data_type  regtype
+start_value  bigint
+min_value  bigint
+max_value  bigint
+increment_by  bigint
+cycle  boolean
+cache_size  bigint
+last_value  bigint

changedpg_stat_activity

--- 9.6
+++ 10
@@ -17,3 +17,4 @@
 backend_xid  xid
 backend_xmin  xid
 query  text
+backend_type  text

changedpg_stat_replication

--- 9.6
+++ 10
@@ -8,9 +8,12 @@
 backend_start  timestamp with time zone
 backend_xmin  xid
 state  text
-sent_location  pg_lsn
-write_location  pg_lsn
-flush_location  pg_lsn
-replay_location  pg_lsn
+sent_lsn  pg_lsn
+write_lsn  pg_lsn
+flush_lsn  pg_lsn
+replay_lsn  pg_lsn
+write_lag  interval
+flush_lag  interval
+replay_lag  interval
 sync_priority  integer
 sync_state  text

addedpg_stat_subscription

--- 9.6
+++ 10
@@ -0,0 +1,9 @@
+subid  oid
+subname  text
+pid  integer
+relid  Oid
+received_lsn  pg_lsn
+last_msg_send_time  timestamp with time zone
+last_msg_receipt_time  timestamp with time zone
+latest_end_lsn  pg_lsn
+latest_end_time  timestamp with time zone

addedpg_statistic_ext

--- 9.6
+++ 10
@@ -0,0 +1,8 @@
+stxrelid  oid
+stxname  name
+stxnamespace  oid
+stxowner  oid
+stxkeys  int2vector
+stxkind  char[]
+stxndistinct  pg_ndistinct
+stxdependencies  pg_dependencies

addedpg_subscription

--- 9.6
+++ 10
@@ -0,0 +1,9 @@
+oid  oid
+subdbid  oid
+subname  name
+subowner  oid
+subenabled  bool
+subsynccommit  text
+subconninfo  text
+subslotname  name
+subpublications  text[]

addedpg_subscription_rel

--- 9.6
+++ 10
@@ -0,0 +1,4 @@
+srsubid  oid
+srrelid  oid
+srsubstate  char
+srsublsn  pg_lsn

changedpg_trigger

--- 9.6
+++ 10
@@ -14,3 +14,5 @@
 tgattr  int2vector
 tgargs  bytea
 tgqual  pg_node_tree
+tgoldtable  name
+tgnewtable  name