What changed?

System Catalogs · PostgreSQL 10 → 11

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

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

--- 10
+++ 11
@@ -11,6 +11,8 @@
 aggmfinalfn  regproc
 aggfinalextra  bool
 aggmfinalextra  bool
+aggfinalmodify  char
+aggmfinalmodify  char
 aggsortop  oid
 aggtranstype  oid
 aggtransspace  int4

changedpg_attribute

--- 10
+++ 11
@@ -12,6 +12,7 @@
 attalign  char
 attnotnull  bool
 atthasdef  bool
+atthasmissing  bool
 attidentity  char
 attisdropped  bool
 attislocal  bool
@@ -20,3 +21,4 @@
 attacl  aclitem[]
 attoptions  text[]
 attfdwoptions  text[]
+attmissingval  anyarray

changedpg_class

--- 10
+++ 11
@@ -18,7 +18,6 @@
 relnatts  int2
 relchecks  int2
 relhasoids  bool
-relhaspkey  bool
 relhasrules  bool
 relhastriggers  bool
 relhassubclass  bool
@@ -27,6 +26,7 @@
 relispopulated  bool
 relreplident  char
 relispartition  bool
+relrewrite  oid
 relfrozenxid  xid
 relminmxid  xid
 relacl  aclitem[]

changedpg_constraint

--- 10
+++ 11
@@ -8,6 +8,7 @@
 conrelid  oid
 contypid  oid
 conindid  oid
+conparentid  oid
 confrelid  oid
 confupdtype  char
 confdeltype  char

changedpg_index

--- 10
+++ 11
@@ -1,6 +1,7 @@
 indexrelid  oid
 indrelid  oid
 indnatts  int2
+indnkeyatts  int2
 indisunique  bool
 indisprimary  bool
 indisexclusion  bool

changedpg_partitioned_table

--- 10
+++ 11
@@ -1,6 +1,7 @@
 partrelid  oid
 partstrat  char
 partnatts  int2
+partdefid  oid
 partattrs  int2vector
 partclass  oidvector
 partcollation  oidvector

changedpg_proc

--- 10
+++ 11
@@ -7,8 +7,7 @@
 prorows  float4
 provariadic  oid
 protransform  regproc
-proisagg  bool
-proiswindow  bool
+prokind  char
 prosecdef  bool
 proleakproof  bool
 proisstrict  bool

changedpg_publication

--- 10
+++ 11
@@ -5,3 +5,4 @@
 pubinsert  bool
 pubupdate  bool
 pubdelete  bool
+pubtruncate  bool

changedpg_stat_wal_receiver

--- 10
+++ 11
@@ -9,4 +9,6 @@
 latest_end_lsn  pg_lsn
 latest_end_time  timestamp with time zone
 slot_name  text
+sender_host  text
+sender_port  integer
 conninfo  text