What changed?

System Catalogs · PostgreSQL 9.4 → 9.5

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

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

--- 9.4
+++ 9.5
@@ -4,9 +4,9 @@
 rolinherit  bool
 rolcreaterole  bool
 rolcreatedb  bool
-rolcatupdate  bool
 rolcanlogin  bool
 rolreplication  bool
+rolbypassrls  bool
 rolconnlimit  int4
 rolpassword  text
 rolvaliduntil  timestamptz

changedpg_class

--- 9.4
+++ 9.5
@@ -22,6 +22,8 @@
 relhasrules  bool
 relhastriggers  bool
 relhassubclass  bool
+relrowsecurity  bool
+relforcerowsecurity  bool
 relispopulated  bool
 relreplident  char
 relfrozenxid  xid

addedpg_file_settings

--- 9.4
+++ 9.5
@@ -0,0 +1,7 @@
+sourcefile  text
+sourceline  integer
+seqno  integer
+name  text
+setting  text
+applied  boolean
+error  text

addedpg_policies

--- 9.4
+++ 9.5
@@ -0,0 +1,7 @@
+schemaname  name
+tablename  name
+policyname  name
+roles  name[]
+cmd  text
+qual  text
+with_check  text

addedpg_policy

--- 9.4
+++ 9.5
@@ -0,0 +1,6 @@
+polname  name
+polrelid  oid
+polcmd  char
+polroles  oid[]
+polqual  pg_node_tree
+polwithcheck  pg_node_tree

changedpg_proc

--- 9.4
+++ 9.5
@@ -22,6 +22,7 @@
 proargmodes  char[]
 proargnames  text[]
 proargdefaults  pg_node_tree
+protrftypes  oid[]
 prosrc  text
 probin  text
 proconfig  text[]

addedpg_replication_origin

--- 9.4
+++ 9.5
@@ -0,0 +1,2 @@
+roident  Oid
+roname  text

addedpg_replication_origin_status

--- 9.4
+++ 9.5
@@ -0,0 +1,4 @@
+local_id  Oid
+external_id  text
+remote_lsn  pg_lsn
+local_lsn  pg_lsn

changedpg_replication_slots

--- 9.4
+++ 9.5
@@ -4,6 +4,7 @@
 datoid  oid
 database  text
 active  boolean
+active_pid  integer
 xmin  xid
 catalog_xmin  xid
 restart_lsn  pg_lsn

changedpg_roles

--- 9.4
+++ 9.5
@@ -3,11 +3,11 @@
 rolinherit  bool
 rolcreaterole  bool
 rolcreatedb  bool
-rolcatupdate  bool
 rolcanlogin  bool
 rolreplication  bool
 rolconnlimit  int4
 rolpassword  text
 rolvaliduntil  timestamptz
+rolbypassrls  bool
 rolconfig  text[]
 oid  oid

changedpg_settings

--- 9.4
+++ 9.5
@@ -14,3 +14,4 @@
 reset_val  text
 sourcefile  text
 sourceline  integer
+pending_restart  boolean

changedpg_shadow

--- 9.4
+++ 9.5
@@ -2,8 +2,8 @@
 usesysid  oid
 usecreatedb  bool
 usesuper  bool
-usecatupd  bool
 userepl  bool
+usebypassrls  bool
 passwd  text
 valuntil  abstime
 useconfig  text[]

addedpg_stat_ssl

--- 9.4
+++ 9.5
@@ -0,0 +1,7 @@
+pid  integer
+ssl  boolean
+version  text
+cipher  text
+bits  integer
+compression  boolean
+clientdn  text

changedpg_tables

--- 9.4
+++ 9.5
@@ -5,3 +5,4 @@
 hasindexes  boolean
 hasrules  boolean
 hastriggers  boolean
+rowsecurity  boolean

addedpg_transform

--- 9.4
+++ 9.5
@@ -0,0 +1,4 @@
+trftype  oid
+trflang  oid
+trffromsql  regproc
+trftosql  regproc

changedpg_user

--- 9.4
+++ 9.5
@@ -2,8 +2,8 @@
 usesysid  oid
 usecreatedb  bool
 usesuper  bool
-usecatupd  bool
 userepl  bool
+usebypassrls  bool
 passwd  text
 valuntil  abstime
 useconfig  text[]