What changed?

System Catalogs · PostgreSQL 9.1 → 9.2

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

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

--- 9.1
+++ 9.2
@@ -7,6 +7,7 @@
 amcanunique  bool
 amcanmulticol  bool
 amoptionalkey  bool
+amsearcharray  bool
 amsearchnulls  bool
 amstorage  bool
 amclusterable  bool
@@ -24,5 +25,6 @@
 ambuildempty  regproc
 ambulkdelete  regproc
 amvacuumcleanup  regproc
+amcanreturn  regproc
 amcostestimate  regproc
 amoptions  regproc

changedpg_attribute

--- 9.1
+++ 9.2
@@ -18,3 +18,4 @@
 attcollation  oid
 attacl  aclitem[]
 attoptions  text[]
+attfdwoptions  text[]

changedpg_class

--- 9.1
+++ 9.2
@@ -8,6 +8,7 @@
 reltablespace  oid
 relpages  int4
 reltuples  float4
+relallvisible  int4
 reltoastrelid  oid
 reltoastidxid  oid
 relhasindex  bool

changedpg_constraint

--- 9.1
+++ 9.2
@@ -13,6 +13,7 @@
 confmatchtype  char
 conislocal  bool
 coninhcount  int4
+connoinherit  bool
 conkey  int2[]
 confkey  int2[]
 conpfeqop  oid[]

changedpg_locks

--- 9.1
+++ 9.2
@@ -12,3 +12,4 @@
 pid  integer
 mode  text
 granted  boolean
+fastpath  boolean

changedpg_proc

--- 9.1
+++ 9.2
@@ -5,9 +5,11 @@
 procost  float4
 prorows  float4
 provariadic  oid
+protransform  regproc
 proisagg  bool
 proiswindow  bool
 prosecdef  bool
+proleakproof  bool
 proisstrict  bool
 proretset  bool
 provolatile  char

addedpg_range

--- 9.1
+++ 9.2
@@ -0,0 +1,6 @@
+rngtypid  oid
+rngsubtype  oid
+rngcollation  oid
+rngsubopc  oid
+rngcanonical  regproc
+rngsubdiff  regproc

changedpg_shadow

--- 9.1
+++ 9.2
@@ -3,6 +3,7 @@
 usecreatedb  bool
 usesuper  bool
 usecatupd  bool
+userepl  bool
 passwd  text
 valuntil  abstime
 useconfig  text[]

addedpg_shseclabel

--- 9.1
+++ 9.2
@@ -0,0 +1,4 @@
+objoid  oid
+classoid  oid
+provider  text
+label  text

changedpg_stat_activity

--- 9.1
+++ 9.2
@@ -1,6 +1,6 @@
 datid  oid
 datname  name
-procpid  integer
+pid  integer
 usesysid  oid
 usename  name
 application_name  text
@@ -10,5 +10,7 @@
 backend_start  timestamp with time zone
 xact_start  timestamp with time zone
 query_start  timestamp with time zone
+state_change  timestamp with time zone
 waiting  boolean
-current_query  text
+state  text
+query  text

changedpg_stat_bgwriter

--- 9.1
+++ 9.2
@@ -1,5 +1,7 @@
 checkpoints_timed  bigint
 checkpoints_req  bigint
+checkpoint_write_time  double precision
+checkpoint_sync_time  double precision
 buffers_checkpoint  bigint
 buffers_clean  bigint
 maxwritten_clean  bigint

changedpg_stat_database

--- 9.1
+++ 9.2
@@ -11,4 +11,9 @@
 tup_updated  bigint
 tup_deleted  bigint
 conflicts  bigint
+temp_files  bigint
+temp_bytes  bigint
+deadlocks  bigint
+blk_read_time  double precision
+blk_write_time  double precision
 stats_reset  timestamp with time zone

changedpg_stat_replication

--- 9.1
+++ 9.2
@@ -1,4 +1,4 @@
-procpid  integer
+pid  integer
 usesysid  oid
 usename  name
 application_name  text

changedpg_stat_user_functions

--- 9.1
+++ 9.2
@@ -2,5 +2,5 @@
 schemaname  name
 funcname  name
 calls  bigint
-total_time  bigint
-self_time  bigint
+total_time  double precision
+self_time  double precision

changedpg_stat_xact_user_functions

--- 9.1
+++ 9.2
@@ -2,5 +2,5 @@
 schemaname  name
 funcname  name
 calls  bigint
-total_time  bigint
-self_time  bigint
+total_time  double precision
+self_time  double precision

changedpg_statistic

--- 9.1
+++ 9.2
@@ -8,15 +8,19 @@
 stakind2  int2
 stakind3  int2
 stakind4  int2
+stakind5  int2
 staop1  oid
 staop2  oid
 staop3  oid
 staop4  oid
+staop5  oid
 stanumbers1  float4[]
 stanumbers2  float4[]
 stanumbers3  float4[]
 stanumbers4  float4[]
+stanumbers5  float4[]
 stavalues1  anyarray
 stavalues2  anyarray
 stavalues3  anyarray
 stavalues4  anyarray
+stavalues5  anyarray

changedpg_stats

--- 9.1
+++ 9.2
@@ -9,3 +9,6 @@
 most_common_freqs  real[]
 histogram_bounds  anyarray
 correlation  real
+most_common_elems  anyarray
+most_common_elem_freqs  real[]
+elem_count_histogram  real[]

changedpg_tablespace

--- 9.1
+++ 9.2
@@ -1,5 +1,4 @@
 spcname  name
 spcowner  oid
-spclocation  text
 spcacl  aclitem[]
 spcoptions  text[]

changedpg_type

--- 9.1
+++ 9.2
@@ -27,3 +27,4 @@
 typcollation  oid
 typdefaultbin  pg_node_tree
 typdefault  text
+typacl  aclitem[]

changedpg_user

--- 9.1
+++ 9.2
@@ -1,8 +1,9 @@
 usename  name
-usesysid  int4
+usesysid  oid
 usecreatedb  bool
 usesuper  bool
 usecatupd  bool
+userepl  bool
 passwd  text
 valuntil  abstime
 useconfig  text[]

changedpg_user_mappings

--- 9.1
+++ 9.2
@@ -1,6 +1,6 @@
 umid  oid
 srvid  oid
-srvname  text
+srvname  name
 umuser  oid
 usename  name
 umoptions  text[]