System Catalogs / Version comparison
What changed?
System Catalogs · PostgreSQL 8.4 → 9.0
Historical documentation for a PostgreSQL version that is no longer supported.
22 added · 1 removed · 13 changed · 0 coverage changes. These are changes between the pinned reference snapshots.
changedpg_attribute
--- 8.4 +++ 9.0 @@ -16,3 +16,4 @@ attislocal bool attinhcount int4 attacl aclitem[] +attoptions text[]
changedpg_authid
--- 8.4 +++ 9.0 @@ -8,4 +8,3 @@ rolconnlimit int4 rolpassword text rolvaliduntil timestamptz -rolconfig text[]
changedpg_class
--- 8.4 +++ 9.0 @@ -1,6 +1,7 @@ relname name relnamespace oid reltype oid +reloftype oid relowner oid relam oid relfilenode oid @@ -17,6 +18,7 @@ relchecks int2 relhasoids bool relhaspkey bool +relhasexclusion bool relhasrules bool relhastriggers bool relhassubclass bool
changedpg_constraint
--- 8.4 +++ 9.0 @@ -5,6 +5,7 @@ condeferred bool conrelid oid contypid oid +conindid oid confrelid oid confupdtype char confdeltype char @@ -16,5 +17,6 @@ conpfeqop oid[] conppeqop oid[] conffeqop oid[] +conexclop oid[] conbin text consrc text
changedpg_database
--- 8.4 +++ 9.0 @@ -9,5 +9,4 @@ datlastsysoid oid datfrozenxid xid dattablespace oid -datconfig text[] datacl aclitem[]
addedpg_db_role_setting
--- 8.4 +++ 9.0 @@ -0,0 +1,3 @@ +setdatabase oid +setrole oid +setconfig text[]
addedpg_default_acl
--- 8.4 +++ 9.0 @@ -0,0 +1,4 @@ +defaclrole oid +defaclnamespace oid +defaclobjtype char +defaclacl aclitem[]
changedpg_index
--- 8.4 +++ 9.0 @@ -3,6 +3,7 @@ indnatts int2 indisunique bool indisprimary bool +indimmediate bool indisclustered bool indisvalid bool indcheckxmin bool
changedpg_language
--- 8.4 +++ 9.0 @@ -3,5 +3,6 @@ lanispl bool lanpltrusted bool lanplcallfoid oid +laninline oid lanvalidator oid lanacl aclitem[]
addedpg_largeobject_metadata
--- 8.4 +++ 9.0 @@ -0,0 +1,2 @@ +lomowner oid +lomacl aclitem[]
removedpg_listener
--- 8.4 +++ 9.0 @@ -1,3 +0,0 @@ -relname name -listenerpid int4 -notification int4
changedpg_pltemplate
--- 8.4 +++ 9.0 @@ -2,6 +2,7 @@ tmpltrusted boolean tmpldbacreate boolean tmplhandler text +tmplinline text tmplvalidator text tmpllibrary text tmplacl aclitem[]
changedpg_proc
--- 8.4 +++ 9.0 @@ -20,6 +20,6 @@ proargnames text[] proargdefaults text prosrc text -probin bytea +probin text proconfig text[] proacl aclitem[]
addedpg_stat_activity
--- 8.4 +++ 9.0 @@ -0,0 +1,13 @@ +datid oid +datname name +procpid integer +usesysid oid +usename name +application_name text +client_addr inet +client_port integer +backend_start timestamp with time zone +xact_start timestamp with time zone +query_start timestamp with time zone +waiting boolean +current_query text
addedpg_stat_all_indexes
--- 8.4 +++ 9.0 @@ -0,0 +1,8 @@ +relid oid +indexrelid oid +schemaname name +relname name +indexrelname name +idx_scan bigint +idx_tup_read bigint +idx_tup_fetch bigint
addedpg_stat_all_tables
--- 8.4 +++ 9.0 @@ -0,0 +1,17 @@ +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 +n_live_tup bigint +n_dead_tup bigint +last_vacuum timestamp with time zone +last_autovacuum timestamp with time zone +last_analyze timestamp with time zone +last_autoanalyze timestamp with time zone
addedpg_stat_bgwriter
--- 8.4 +++ 9.0 @@ -0,0 +1,7 @@ +checkpoints_timed bigint +checkpoints_req bigint +buffers_checkpoint bigint +buffers_clean bigint +maxwritten_clean bigint +buffers_backend bigint +buffers_alloc bigint
addedpg_stat_database
--- 8.4 +++ 9.0 @@ -0,0 +1,12 @@ +datid oid +datname name +numbackends integer +xact_commit bigint +xact_rollback bigint +blks_read bigint +blks_hit bigint +tup_returned bigint +tup_fetched bigint +tup_inserted bigint +tup_updated bigint +tup_deleted bigint
addedpg_stat_sys_indexes
--- 8.4 +++ 9.0 @@ -0,0 +1,8 @@ +relid oid +indexrelid oid +schemaname name +relname name +indexrelname name +idx_scan bigint +idx_tup_read bigint +idx_tup_fetch bigint
addedpg_stat_sys_tables
--- 8.4 +++ 9.0 @@ -0,0 +1,17 @@ +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 +n_live_tup bigint +n_dead_tup bigint +last_vacuum timestamp with time zone +last_autovacuum timestamp with time zone +last_analyze timestamp with time zone +last_autoanalyze timestamp with time zone
addedpg_stat_user_functions
--- 8.4 +++ 9.0 @@ -0,0 +1,6 @@ +funcid oid +schemaname name +funcname name +calls bigint +total_time bigint +self_time bigint
addedpg_stat_user_indexes
--- 8.4 +++ 9.0 @@ -0,0 +1,8 @@ +relid oid +indexrelid oid +schemaname name +relname name +indexrelname name +idx_scan bigint +idx_tup_read bigint +idx_tup_fetch bigint
addedpg_stat_user_tables
--- 8.4 +++ 9.0 @@ -0,0 +1,17 @@ +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 +n_live_tup bigint +n_dead_tup bigint +last_vacuum timestamp with time zone +last_autovacuum timestamp with time zone +last_analyze timestamp with time zone +last_autoanalyze timestamp with time zone
addedpg_statio_all_indexes
--- 8.4 +++ 9.0 @@ -0,0 +1,7 @@ +relid oid +indexrelid oid +schemaname name +relname name +indexrelname name +idx_blks_read bigint +idx_blks_hit bigint
addedpg_statio_all_sequences
--- 8.4 +++ 9.0 @@ -0,0 +1,5 @@ +relid oid +schemaname name +relname name +blks_read bigint +blks_hit bigint
addedpg_statio_all_tables
--- 8.4 +++ 9.0 @@ -0,0 +1,11 @@ +relid oid +schemaname name +relname name +heap_blks_read bigint +heap_blks_hit bigint +idx_blks_read bigint +idx_blks_hit bigint +toast_blks_read bigint +toast_blks_hit bigint +tidx_blks_read bigint +tidx_blks_hit bigint
addedpg_statio_sys_indexes
--- 8.4 +++ 9.0 @@ -0,0 +1,7 @@ +relid oid +indexrelid oid +schemaname name +relname name +indexrelname name +idx_blks_read bigint +idx_blks_hit bigint
addedpg_statio_sys_sequences
--- 8.4 +++ 9.0 @@ -0,0 +1,5 @@ +relid oid +schemaname name +relname name +blks_read bigint +blks_hit bigint
addedpg_statio_sys_tables
--- 8.4 +++ 9.0 @@ -0,0 +1,11 @@ +relid oid +schemaname name +relname name +heap_blks_read bigint +heap_blks_hit bigint +idx_blks_read bigint +idx_blks_hit bigint +toast_blks_read bigint +toast_blks_hit bigint +tidx_blks_read bigint +tidx_blks_hit bigint
addedpg_statio_user_indexes
--- 8.4 +++ 9.0 @@ -0,0 +1,7 @@ +relid oid +indexrelid oid +schemaname name +relname name +indexrelname name +idx_blks_read bigint +idx_blks_hit bigint
addedpg_statio_user_sequences
--- 8.4 +++ 9.0 @@ -0,0 +1,5 @@ +relid oid +schemaname name +relname name +blks_read bigint +blks_hit bigint
addedpg_statio_user_tables
--- 8.4 +++ 9.0 @@ -0,0 +1,11 @@ +relid oid +schemaname name +relname name +heap_blks_read bigint +heap_blks_hit bigint +idx_blks_read bigint +idx_blks_hit bigint +toast_blks_read bigint +toast_blks_hit bigint +tidx_blks_read bigint +tidx_blks_hit bigint
changedpg_statistic
--- 8.4 +++ 9.0 @@ -1,9 +1,22 @@ starelid oid staattnum int2 +stainherit bool stanullfrac float4 stawidth int4 stadistinct float4 -stakindN int2 -staopN oid -stanumbersN float4[] -stavaluesN anyarray +stakind1 int2 +stakind2 int2 +stakind3 int2 +stakind4 int2 +staop1 oid +staop2 oid +staop3 oid +staop4 oid +stanumbers1 float4[] +stanumbers2 float4[] +stanumbers3 float4[] +stanumbers4 float4[] +stavalues1 anyarray +stavalues2 anyarray +stavalues3 anyarray +stavalues4 anyarray
changedpg_stats
--- 8.4 +++ 9.0 @@ -1,6 +1,7 @@ schemaname name tablename name attname name +inherited bool null_frac real avg_width integer n_distinct real
changedpg_tablespace
--- 8.4 +++ 9.0 @@ -2,3 +2,4 @@ spcowner oid spclocation text spcacl aclitem[] +spcoptions text[]
changedpg_trigger
--- 8.4 +++ 9.0 @@ -3,12 +3,13 @@ tgfoid oid tgtype int2 tgenabled char -tgisconstraint bool -tgconstrname name +tgisinternal bool tgconstrrelid oid +tgconstrindid oid tgconstraint oid tgdeferrable bool tginitdeferred bool tgnargs int2 tgattr int2vector tgargs bytea +tgqual text