Skip to content

FOLLOW THE EVOLUTION

PostgreSQL 12 Catalog Changes

Start from a single upgrade and see how catalogs, columns, and types changed.
Compare any two versions, or walk forward through the release history.

PostgreSQL 11 → 12
pg_amStructural change
~ oid: implicit → ordinary
pg_amopStructural change
~ oid: implicit → ordinary
pg_amprocStructural change
~ oid: implicit → ordinary
pg_attrdefStructural change
− adsrc~ adbin: not_null: false → true~ oid: implicit → ordinary
pg_authidStructural change
~ oid: implicit → ordinary
pg_castStructural change
~ oid: implicit → ordinary
pg_classStructural change
− relhasoids~ oid: implicit → ordinary
pg_collationStructural change
+ collisdeterministic~ oid: implicit → ordinary
pg_constraintStructural change
− consrc~ oid: implicit → ordinary
pg_databaseStructural change
~ oid: implicit → ordinary
pg_default_aclStructural change
~ defaclacl: not_null: false → true~ oid: implicit → ordinary
pg_enumStructural change
~ oid: implicit → ordinary
pg_languageStructural change
~ oid: implicit → ordinary
pg_opclassStructural change
~ oid: implicit → ordinary
pg_operatorStructural change
~ oid: implicit → ordinary
pg_opfamilyStructural change
~ oid: implicit → ordinary
pg_policyStructural change
~ oid: implicit → ordinary~ polroles: not_null: false → true
pg_procStructural change
+ prosupport− protransform~ oid: implicit → ordinary
pg_rewriteStructural change
~ ev_action: not_null: false → true~ ev_qual: not_null: false → true~ oid: implicit → ordinary
pg_shadowStructural change
~ valuntil: abstime → timestamp with time zone
pg_stat_gssapiCatalog added
+ pid+ gss_authenticated+ principal+ encrypted
pg_stat_progress_clusterCatalog added
+ pid+ datid+ datname+ relid+ command+ phase+ cluster_index_relid+ heap_tuples_scanned+ heap_tuples_written+ heap_blks_total+ heap_blks_scanned+ index_rebuild_count
pg_stat_progress_create_indexCatalog added
+ pid+ datid+ datname+ relid+ index_relid+ command+ phase+ lockers_total+ lockers_done+ current_locker_pid+ blocks_total+ blocks_done+ tuples_total+ tuples_done+ partitions_total+ partitions_done
pg_stat_sslStructural change
+ client_dn+ client_serial+ issuer_dn− clientdn
pg_statisticStructural change
+ stacoll1+ stacoll2+ stacoll3+ stacoll4+ stacoll5
pg_statistic_extStructural change
− stxndistinct− stxdependencies~ oid: implicit → ordinary
pg_stats_extCatalog added
+ schemaname+ tablename+ statistics_schemaname+ statistics_name+ statistics_owner+ attnames+ kinds+ n_distinct+ dependencies+ most_common_vals+ most_common_val_nulls+ most_common_freqs+ most_common_base_freqs
pg_triggerStructural change
~ oid: implicit → ordinary
pg_ts_dictStructural change
~ oid: implicit → ordinary
pg_typeStructural change
~ oid: implicit → ordinary
pg_userStructural change
~ valuntil: abstime → timestamp with time zone