What changed?

System Catalogs · PostgreSQL 8.3 → 8.4

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

4 added · 1 removed · 11 changed · 0 coverage changes. These are changes between the pinned reference snapshots.

--- 8.3
+++ 8.4
@@ -2,6 +2,7 @@
 amstrategies  int2
 amsupport  int2
 amcanorder  bool
+amcanbackward  bool
 amcanunique  bool
 amcanmulticol  bool
 amoptionalkey  bool
@@ -9,10 +10,11 @@
 amsearchnulls  bool
 amstorage  bool
 amclusterable  bool
+amkeytype  oid
 aminsert  regproc
 ambeginscan  regproc
 amgettuple  regproc
-amgetmulti  regproc
+amgetbitmap  regproc
 amrescan  regproc
 amendscan  regproc
 ammarkpos  regproc

changedpg_amop

--- 8.3
+++ 8.4
@@ -2,6 +2,5 @@
 amoplefttype  oid
 amoprighttype  oid
 amopstrategy  int2
-amopreqcheck  bool
 amopopr  oid
 amopmethod  oid

changedpg_attribute

--- 8.3
+++ 8.4
@@ -15,3 +15,4 @@
 attisdropped  bool
 attislocal  bool
 attinhcount  int4
+attacl  aclitem[]

removedpg_autovacuum

--- 8.3
+++ 8.4
@@ -1,10 +0,0 @@
-vacrelid  oid
-enabled  bool
-vac_base_thresh  integer
-vac_scale_factor  float4
-anl_base_thresh  integer
-anl_scale_factor  float4
-vac_cost_delay  integer
-vac_cost_limit  integer
-freeze_min_age  integer
-freeze_max_age  integer

changedpg_cast

--- 8.3
+++ 8.4
@@ -2,3 +2,4 @@
 casttarget  oid
 castfunc  oid
 castcontext  char
+castmethod  char

changedpg_class

--- 8.3
+++ 8.4
@@ -11,16 +11,14 @@
 reltoastidxid  oid
 relhasindex  bool
 relisshared  bool
+relistemp  bool
 relkind  char
 relnatts  int2
 relchecks  int2
-reltriggers  int2
-relukeys  int2
-relfkeys  int2
-relrefs  int2
 relhasoids  bool
 relhaspkey  bool
 relhasrules  bool
+relhastriggers  bool
 relhassubclass  bool
 relfrozenxid  xid
 relacl  aclitem[]

changedpg_constraint

--- 8.3
+++ 8.4
@@ -9,6 +9,8 @@
 confupdtype  char
 confdeltype  char
 confmatchtype  char
+conislocal  bool
+coninhcount  int4
 conkey  int2[]
 confkey  int2[]
 conpfeqop  oid[]

changedpg_database

--- 8.3
+++ 8.4
@@ -1,6 +1,8 @@
 datname  name
 datdba  oid
 encoding  int4
+datcollate  name
+datctype  name
 datistemplate  bool
 datallowconn  bool
 datconnlimit  int4

addedpg_foreign_data_wrapper

--- 8.3
+++ 8.4
@@ -0,0 +1,5 @@
+fdwname  name
+fdwowner  oid
+fdwvalidator  oid
+fdwacl  aclitem[]
+fdwoptions  text[]

addedpg_foreign_server

--- 8.3
+++ 8.4
@@ -0,0 +1,7 @@
+srvname  name
+srvowner  oid
+srvfdw  oid
+srvtype  text
+srvversion  text
+srvacl  aclitem[]
+srvoptions  text[]

changedpg_proc

--- 8.3
+++ 8.4
@@ -4,17 +4,21 @@
 prolang  oid
 procost  float4
 prorows  float4
+provariadic  oid
 proisagg  bool
+proiswindow  bool
 prosecdef  bool
 proisstrict  bool
 proretset  bool
 provolatile  char
 pronargs  int2
+pronargdefaults  int2
 prorettype  oid
 proargtypes  oidvector
 proallargtypes  oid[]
 proargmodes  char[]
 proargnames  text[]
+proargdefaults  text
 prosrc  text
 probin  bytea
 proconfig  text[]

changedpg_settings

--- 8.3
+++ 8.4
@@ -9,3 +9,8 @@
 source  text
 min_val  text
 max_val  text
+enumvals  text[]
+boot_val  text
+reset_val  text
+sourcefile  text
+sourceline  integer

changedpg_shdepend

--- 8.3
+++ 8.4
@@ -1,6 +1,7 @@
 dbid  oid
 classid  oid
 objid  oid
+objsubid  int4
 refclassid  oid
 refobjid  oid
 deptype  char

changedpg_type

--- 8.3
+++ 8.4
@@ -4,6 +4,8 @@
 typlen  int2
 typbyval  bool
 typtype  char
+typcategory  char
+typispreferred  bool
 typisdefined  bool
 typdelim  char
 typrelid  oid

addedpg_user_mapping

--- 8.3
+++ 8.4
@@ -0,0 +1,3 @@
+umuser  oid
+umserver  oid
+umoptions  text[]

addedpg_user_mappings

--- 8.3
+++ 8.4
@@ -0,0 +1,6 @@
+umid  oid
+srvid  oid
+srvname  text
+umuser  oid
+usename  name
+umoptions  text[]