SYSTEM CATALOGS / VERSION COMPARISON
What changed?
System Catalogs · PostgreSQL 9.0 → 9.1
Historical documentation for a PostgreSQL version that is no longer supported.
13 added · 0 removed · 21 changed · 0 coverage changes. These are changes in the pinned reference snapshots.
changedpg_am
--- 9.0 +++ 9.1 @@ -2,14 +2,15 @@ amstrategies int2 amsupport int2 amcanorder bool +amcanorderbyop bool amcanbackward bool amcanunique bool amcanmulticol bool amoptionalkey bool -amindexnulls bool amsearchnulls bool amstorage bool amclusterable bool +ampredlocks bool amkeytype oid aminsert regproc ambeginscan regproc @@ -20,6 +21,7 @@ ammarkpos regproc amrestrpos regproc ambuild regproc +ambuildempty regproc ambulkdelete regproc amvacuumcleanup regproc amcostestimate regproc
changedpg_amop
--- 9.0 +++ 9.1 @@ -2,5 +2,7 @@ amoplefttype oid amoprighttype oid amopstrategy int2 +amoppurpose char amopopr oid amopmethod oid +amopsortfamily oid
changedpg_attrdef
--- 9.0 +++ 9.1 @@ -1,4 +1,4 @@ adrelid oid adnum int2 -adbin text +adbin pg_node_tree adsrc text
changedpg_attribute
--- 9.0 +++ 9.1 @@ -15,5 +15,6 @@ attisdropped bool attislocal bool attinhcount int4 +attcollation oid attacl aclitem[] attoptions text[]
changedpg_authid
--- 9.0 +++ 9.1 @@ -5,6 +5,7 @@ rolcreatedb bool rolcatupdate bool rolcanlogin bool +rolreplication bool rolconnlimit int4 rolpassword text rolvaliduntil timestamptz
addedpg_available_extension_versions
--- 9.0 +++ 9.1 @@ -0,0 +1,8 @@ +name name +version text +installed bool +superuser bool +relocatable bool +schema name +requires name[] +comment text
addedpg_available_extensions
--- 9.0 +++ 9.1 @@ -0,0 +1,4 @@ +name name +default_version text +installed_version text +comment text
changedpg_class
--- 9.0 +++ 9.1 @@ -12,13 +12,12 @@ reltoastidxid oid relhasindex bool relisshared bool -relistemp bool +relpersistence char relkind char relnatts int2 relchecks int2 relhasoids bool relhaspkey bool -relhasexclusion bool relhasrules bool relhastriggers bool relhassubclass bool
addedpg_collation
--- 9.0 +++ 9.1 @@ -0,0 +1,6 @@ +collname name +collnamespace oid +collowner oid +collencoding int4 +collcollate name +collctype name
changedpg_constraint
--- 9.0 +++ 9.1 @@ -3,6 +3,7 @@ contype char condeferrable bool condeferred bool +convalidated bool conrelid oid contypid oid conindid oid @@ -18,5 +19,5 @@ conppeqop oid[] conffeqop oid[] conexclop oid[] -conbin text +conbin pg_node_tree consrc text
changedpg_enum
--- 9.0 +++ 9.1 @@ -1,2 +1,3 @@ enumtypid oid +enumsortorder float4 enumlabel name
addedpg_extension
--- 9.0 +++ 9.1 @@ -0,0 +1,7 @@ +extname name +extowner oid +extnamespace oid +extrelocatable bool +extversion text +extconfig oid[] +extcondition text[]
changedpg_foreign_data_wrapper
--- 9.0 +++ 9.1 @@ -1,5 +1,6 @@ fdwname name fdwowner oid +fdwhandler oid fdwvalidator oid fdwacl aclitem[] fdwoptions text[]
addedpg_foreign_table
--- 9.0 +++ 9.1 @@ -0,0 +1,3 @@ +ftrelid oid +ftserver oid +ftoptions text[]
changedpg_index
--- 9.0 +++ 9.1 @@ -3,13 +3,15 @@ indnatts int2 indisunique bool indisprimary bool +indisexclusion bool indimmediate bool indisclustered bool indisvalid bool indcheckxmin bool indisready bool indkey int2vector +indcollation oidvector indclass oidvector indoption int2vector -indexprs text -indpred text +indexprs pg_node_tree +indpred pg_node_tree
changedpg_proc
--- 9.0 +++ 9.1 @@ -18,7 +18,7 @@ proallargtypes oid[] proargmodes char[] proargnames text[] -proargdefaults text +proargdefaults pg_node_tree prosrc text probin text proconfig text[]
changedpg_rewrite
--- 9.0 +++ 9.1 @@ -4,5 +4,5 @@ ev_type char ev_enabled char is_instead bool -ev_qual text -ev_action text +ev_qual pg_node_tree +ev_action pg_node_tree
changedpg_roles
--- 9.0 +++ 9.1 @@ -5,6 +5,7 @@ rolcreatedb bool rolcatupdate bool rolcanlogin bool +rolreplication bool rolconnlimit int4 rolpassword text rolvaliduntil timestamptz
addedpg_seclabel
--- 9.0 +++ 9.1 @@ -0,0 +1,5 @@ +objoid oid +classoid oid +objsubid int4 +provider text +label text
addedpg_seclabels
--- 9.0 +++ 9.1 @@ -0,0 +1,8 @@ +objoid oid +classoid oid +objsubid int4 +objtype text +objnamespace oid +objname text +provider text +label text
changedpg_stat_activity
--- 9.0 +++ 9.1 @@ -5,6 +5,7 @@ usename name application_name text client_addr inet +client_hostname text client_port integer backend_start timestamp with time zone xact_start timestamp with time zone
changedpg_stat_all_tables
--- 9.0 +++ 9.1 @@ -15,3 +15,7 @@ last_autovacuum timestamp with time zone last_analyze timestamp with time zone last_autoanalyze timestamp with time zone +vacuum_count bigint +autovacuum_count bigint +analyze_count bigint +autoanalyze_count bigint
changedpg_stat_bgwriter
--- 9.0 +++ 9.1 @@ -4,4 +4,6 @@ buffers_clean bigint maxwritten_clean bigint buffers_backend bigint +buffers_backend_fsync bigint buffers_alloc bigint +stats_reset timestamp with time zone
changedpg_stat_database
--- 9.0 +++ 9.1 @@ -10,3 +10,5 @@ tup_inserted bigint tup_updated bigint tup_deleted bigint +conflicts bigint +stats_reset timestamp with time zone
addedpg_stat_database_conflicts
--- 9.0 +++ 9.1 @@ -0,0 +1,7 @@ +datid oid +datname name +confl_tablespace bigint +confl_lock bigint +confl_snapshot bigint +confl_bufferpin bigint +confl_deadlock bigint
addedpg_stat_replication
--- 9.0 +++ 9.1 @@ -0,0 +1,15 @@ +procpid integer +usesysid oid +usename name +application_name text +client_addr inet +client_hostname text +client_port integer +backend_start timestamp with time zone +state text +sent_location text +write_location text +flush_location text +replay_location text +sync_priority integer +sync_state text
changedpg_stat_sys_tables
--- 9.0 +++ 9.1 @@ -15,3 +15,7 @@ last_autovacuum timestamp with time zone last_analyze timestamp with time zone last_autoanalyze timestamp with time zone +vacuum_count bigint +autovacuum_count bigint +analyze_count bigint +autoanalyze_count bigint
changedpg_stat_user_tables
--- 9.0 +++ 9.1 @@ -15,3 +15,7 @@ last_autovacuum timestamp with time zone last_analyze timestamp with time zone last_autoanalyze timestamp with time zone +vacuum_count bigint +autovacuum_count bigint +analyze_count bigint +autoanalyze_count bigint
addedpg_stat_xact_all_tables
--- 9.0 +++ 9.1 @@ -0,0 +1,11 @@ +relid oid +schemaname name +relname name +seq_scan bigint +seq_tup_read bigint +idx_scan bigint +idx_tup_fetch bigint +n_tup_ins bigint +n_tup_upd bigint +n_tup_del bigint +n_tup_hot_upd bigint
addedpg_stat_xact_sys_tables
--- 9.0 +++ 9.1 @@ -0,0 +1,11 @@ +relid oid +schemaname name +relname name +seq_scan bigint +seq_tup_read bigint +idx_scan bigint +idx_tup_fetch bigint +n_tup_ins bigint +n_tup_upd bigint +n_tup_del bigint +n_tup_hot_upd bigint
addedpg_stat_xact_user_functions
--- 9.0 +++ 9.1 @@ -0,0 +1,6 @@ +funcid oid +schemaname name +funcname name +calls bigint +total_time bigint +self_time bigint
addedpg_stat_xact_user_tables
--- 9.0 +++ 9.1 @@ -0,0 +1,11 @@ +relid oid +schemaname name +relname name +seq_scan bigint +seq_tup_read bigint +idx_scan bigint +idx_tup_fetch bigint +n_tup_ins bigint +n_tup_upd bigint +n_tup_del bigint +n_tup_hot_upd bigint
changedpg_trigger
--- 9.0 +++ 9.1 @@ -12,4 +12,4 @@ tgnargs int2 tgattr int2vector tgargs bytea -tgqual text +tgqual pg_node_tree
changedpg_type
--- 9.0 +++ 9.1 @@ -24,5 +24,6 @@ typbasetype oid typtypmod int4 typndims int4 -typdefaultbin text +typcollation oid +typdefaultbin pg_node_tree typdefault text