What changed?

System Catalogs · PostgreSQL 9.5 → 9.6

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

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

--- 9.5
+++ 9.6
@@ -3,6 +3,9 @@
 aggnumdirectargs  int2
 aggtransfn  regproc
 aggfinalfn  regproc
+aggcombinefn  regproc
+aggserialfn  regproc
+aggdeserialfn  regproc
 aggmtransfn  regproc
 aggminvtransfn  regproc
 aggmfinalfn  regproc

changedpg_am

--- 9.5
+++ 9.6
@@ -1,31 +1,4 @@
 oid  oid
 amname  name
-amstrategies  int2
-amsupport  int2
-amcanorder  bool
-amcanorderbyop  bool
-amcanbackward  bool
-amcanunique  bool
-amcanmulticol  bool
-amoptionalkey  bool
-amsearcharray  bool
-amsearchnulls  bool
-amstorage  bool
-amclusterable  bool
-ampredlocks  bool
-amkeytype  oid
-aminsert  regproc
-ambeginscan  regproc
-amgettuple  regproc
-amgetbitmap  regproc
-amrescan  regproc
-amendscan  regproc
-ammarkpos  regproc
-amrestrpos  regproc
-ambuild  regproc
-ambuildempty  regproc
-ambulkdelete  regproc
-amvacuumcleanup  regproc
-amcanreturn  regproc
-amcostestimate  regproc
-amoptions  regproc
+amhandler  regproc
+amtype  char

addedpg_config

--- 9.5
+++ 9.6
@@ -0,0 +1,2 @@
+name  text
+setting  text

addedpg_init_privs

--- 9.5
+++ 9.6
@@ -0,0 +1,5 @@
+objoid  oid
+classoid  oid
+objsubid  int4
+privtype  char
+initprivs  aclitem[]

changedpg_proc

--- 9.5
+++ 9.6
@@ -14,6 +14,7 @@
 proisstrict  bool
 proretset  bool
 provolatile  char
+proparallel  char
 pronargs  int2
 pronargdefaults  int2
 prorettype  oid

changedpg_replication_slots

--- 9.5
+++ 9.6
@@ -8,3 +8,4 @@
 xmin  xid
 catalog_xmin  xid
 restart_lsn  pg_lsn
+confirmed_flush_lsn  pg_lsn

changedpg_stat_activity

--- 9.5
+++ 9.6
@@ -11,7 +11,8 @@
 xact_start  timestamp with time zone
 query_start  timestamp with time zone
 state_change  timestamp with time zone
-waiting  boolean
+wait_event_type  text
+wait_event  text
 state  text
 backend_xid  xid
 backend_xmin  xid

addedpg_stat_progress_vacuum

--- 9.5
+++ 9.6
@@ -0,0 +1,11 @@
+pid  integer
+datid  oid
+datname  name
+relid  oid
+phase  text
+heap_blks_total  bigint
+heap_blks_scanned  bigint
+heap_blks_vacuumed  bigint
+index_vacuum_count  bigint
+max_dead_tuples  bigint
+num_dead_tuples  bigint

addedpg_stat_wal_receiver

--- 9.5
+++ 9.6
@@ -0,0 +1,12 @@
+pid  integer
+status  text
+receive_start_lsn  pg_lsn
+receive_start_tli  integer
+received_lsn  pg_lsn
+received_tli  integer
+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
+slot_name  text
+conninfo  text