SYSTEM CATALOGS / VERSION COMPARISON
What changed?
System Catalogs · PostgreSQL 12 → 13
Historical documentation for a PostgreSQL version that is no longer supported.
4 added · 1 removed · 34 changed · 0 coverage changes. These are changes in the pinned reference snapshots.
changedpg_available_extension_versions
--- 12 +++ 13 @@ -2,6 +2,7 @@ version text installed bool superuser bool +trusted bool relocatable bool schema name requires name[]
changedpg_cursors
--- 12 +++ 13 @@ -1,6 +1,6 @@ name text statement text -is_holdable boolean -is_binary boolean -is_scrollable boolean +is_holdable bool +is_binary bool +is_scrollable bool creation_time timestamptz
changedpg_event_trigger
--- 12 +++ 13 @@ -1,3 +1,4 @@ +oid oid evtname name evtevent name evtowner oid
changedpg_file_settings
--- 12 +++ 13 @@ -1,7 +1,7 @@ sourcefile text -sourceline integer -seqno integer +sourceline int4 +seqno int4 name text setting text -applied boolean +applied bool error text
changedpg_hba_file_rules
--- 12 +++ 13 @@ -1,4 +1,4 @@ -line_number integer +line_number int4 type text database text[] user_name text[]
changedpg_locks
--- 12 +++ 13 @@ -1,15 +1,15 @@ locktype text database oid relation oid -page integer -tuple smallint +page int4 +tuple int2 virtualxid text transactionid xid classid oid objid oid -objsubid smallint +objsubid int2 virtualtransaction text -pid integer +pid int4 mode text -granted boolean -fastpath boolean +granted bool +fastpath bool
changedpg_matviews
--- 12 +++ 13 @@ -2,6 +2,6 @@ matviewname name matviewowner name tablespace name -hasindexes boolean -ispopulated boolean +hasindexes bool +ispopulated bool definition text
removedpg_pltemplate
--- 12 +++ 13 @@ -1,8 +0,0 @@ -tmplname name -tmpltrusted boolean -tmpldbacreate boolean -tmplhandler text -tmplinline text -tmplvalidator text -tmpllibrary text -tmplacl aclitem[]
changedpg_policies
--- 12 +++ 13 @@ -1,7 +1,7 @@ schemaname name tablename name policyname name -polpermissive text +permissive text roles name[] cmd text qual text
changedpg_policy
--- 12 +++ 13 @@ -1,7 +1,8 @@ +oid oid polname name polrelid oid polcmd char -polpermissive boolean +polpermissive bool polroles oid[] polqual pg_node_tree polwithcheck pg_node_tree
changedpg_prepared_statements
--- 12 +++ 13 @@ -2,4 +2,4 @@ statement text prepare_time timestamptz parameter_types regtype[] -from_sql boolean +from_sql bool
changedpg_prepared_xacts
--- 12 +++ 13 @@ -1,5 +1,5 @@ transaction xid gid text -prepared timestamp with time zone +prepared timestamptz owner name database name
changedpg_publication
--- 12 +++ 13 @@ -6,3 +6,4 @@ pubupdate bool pubdelete bool pubtruncate bool +pubviaroot bool
changedpg_publication_rel
--- 12 +++ 13 @@ -1,2 +1,3 @@ +oid oid prpubid oid prrelid oid
changedpg_replication_origin
--- 12 +++ 13 @@ -1,2 +1,2 @@ -roident Oid +roident oid roname text
changedpg_replication_origin_status
--- 12 +++ 13 @@ -1,4 +1,4 @@ -local_id Oid +local_id oid external_id text remote_lsn pg_lsn local_lsn pg_lsn
changedpg_replication_slots
--- 12 +++ 13 @@ -2,11 +2,13 @@ plugin name slot_type text datoid oid -database text -temporary boolean -active boolean -active_pid integer +database name +temporary bool +active bool +active_pid int4 xmin xid catalog_xmin xid restart_lsn pg_lsn confirmed_flush_lsn pg_lsn +wal_status text +safe_wal_size int8
changedpg_sequences
--- 12 +++ 13 @@ -2,10 +2,10 @@ sequencename name sequenceowner name data_type regtype -start_value bigint -min_value bigint -max_value bigint -increment_by bigint -cycle boolean -cache_size bigint -last_value bigint +start_value int8 +min_value int8 +max_value int8 +increment_by int8 +cycle bool +cache_size int8 +last_value int8
changedpg_settings
--- 12 +++ 13 @@ -13,5 +13,5 @@ boot_val text reset_val text sourcefile text -sourceline integer -pending_restart boolean +sourceline int4 +pending_restart bool
addedpg_shmem_allocations
--- 12 +++ 13 @@ -0,0 +1,4 @@ +name text +off int8 +size int8 +allocated_size int8
changedpg_stat_activity
--- 12 +++ 13 @@ -1,6 +1,7 @@ datid oid datname name pid integer +leader_pid integer usesysid oid usename name application_name text
changedpg_stat_all_tables
--- 12 +++ 13 @@ -12,6 +12,7 @@ n_live_tup bigint n_dead_tup bigint n_mod_since_analyze bigint +n_ins_since_vacuum bigint last_vacuum timestamp with time zone last_autovacuum timestamp with time zone last_analyze timestamp with time zone
addedpg_stat_progress_analyze
--- 12 +++ 13 @@ -0,0 +1,12 @@ +pid integer +datid oid +datname name +relid oid +phase text +sample_blks_total bigint +sample_blks_scanned bigint +ext_stats_total bigint +ext_stats_computed bigint +child_tables_total bigint +child_tables_done bigint +current_child_table_relid oid
addedpg_stat_progress_basebackup
--- 12 +++ 13 @@ -0,0 +1,6 @@ +pid integer +phase text +backup_total bigint +backup_streamed bigint +tablespaces_total bigint +tablespaces_streamed bigint
addedpg_stat_slru
--- 12 +++ 13 @@ -0,0 +1,9 @@ +name text +blks_zeroed bigint +blks_hit bigint +blks_read bigint +blks_written bigint +blks_exists bigint +flushes bigint +truncates bigint +stats_reset timestamp with time zone
changedpg_stat_subscription
--- 12 +++ 13 @@ -1,7 +1,7 @@ subid oid -subname text +subname name pid integer -relid Oid +relid oid received_lsn pg_lsn last_msg_send_time timestamp with time zone last_msg_receipt_time timestamp with time zone
changedpg_stat_sys_tables
--- 12 +++ 13 @@ -12,6 +12,7 @@ n_live_tup bigint n_dead_tup bigint n_mod_since_analyze bigint +n_ins_since_vacuum bigint last_vacuum timestamp with time zone last_autovacuum timestamp with time zone last_analyze timestamp with time zone
changedpg_stat_user_tables
--- 12 +++ 13 @@ -12,6 +12,7 @@ n_live_tup bigint n_dead_tup bigint n_mod_since_analyze bigint +n_ins_since_vacuum bigint last_vacuum timestamp with time zone last_autovacuum timestamp with time zone last_analyze timestamp with time zone
changedpg_stat_wal_receiver
--- 12 +++ 13 @@ -2,7 +2,8 @@ status text receive_start_lsn pg_lsn receive_start_tli integer -received_lsn pg_lsn +written_lsn pg_lsn +flushed_lsn pg_lsn received_tli integer last_msg_send_time timestamp with time zone last_msg_receipt_time timestamp with time zone
changedpg_statistic_ext
--- 12 +++ 13 @@ -1,6 +1,8 @@ +oid oid stxrelid oid stxname name stxnamespace oid stxowner oid +stxstattarget int4 stxkeys int2vector stxkind char[]
changedpg_stats
--- 12 +++ 13 @@ -2,13 +2,13 @@ tablename name attname name inherited bool -null_frac real -avg_width integer -n_distinct real +null_frac float4 +avg_width int4 +n_distinct float4 most_common_vals anyarray -most_common_freqs real[] +most_common_freqs float4[] histogram_bounds anyarray -correlation real +correlation float4 most_common_elems anyarray -most_common_elem_freqs real[] -elem_count_histogram real[] +most_common_elem_freqs float4[] +elem_count_histogram float4[]
changedpg_stats_ext
--- 12 +++ 13 @@ -2,12 +2,12 @@ tablename name statistics_schemaname name statistics_name name -statistics_owner oid +statistics_owner name attnames name[] -kinds text[] +kinds char[] n_distinct pg_ndistinct dependencies pg_dependencies -most_common_vals anyarray -most_common_val_nulls anyarray -most_common_freqs real[] -most_common_base_freqs real[] +most_common_vals text[] +most_common_val_nulls bool[] +most_common_freqs float8[] +most_common_base_freqs float8[]
changedpg_subscription
--- 12 +++ 13 @@ -3,7 +3,7 @@ subname name subowner oid subenabled bool -subsynccommit text subconninfo text subslotname name +subsynccommit text subpublications text[]
changedpg_tables
--- 12 +++ 13 @@ -2,7 +2,7 @@ tablename name tableowner name tablespace name -hasindexes boolean -hasrules boolean -hastriggers boolean -rowsecurity boolean +hasindexes bool +hasrules bool +hastriggers bool +rowsecurity bool
changedpg_timezone_abbrevs
--- 12 +++ 13 @@ -1,3 +1,3 @@ abbrev text utc_offset interval -is_dst boolean +is_dst bool
changedpg_timezone_names
--- 12 +++ 13 @@ -1,4 +1,4 @@ name text abbrev text utc_offset interval -is_dst boolean +is_dst bool
changedpg_transform
--- 12 +++ 13 @@ -1,3 +1,4 @@ +oid oid trftype oid trflang oid trffromsql regproc
changedpg_trigger
--- 12 +++ 13 @@ -1,5 +1,6 @@ oid oid tgrelid oid +tgparentid oid tgname name tgfoid oid tgtype int2
changedpg_ts_config_map
--- 12 +++ 13 @@ -1,4 +1,4 @@ mapcfg oid -maptokentype integer -mapseqno integer +maptokentype int4 +mapseqno int4 mapdict oid