Skip to content

FOLLOW THE EVOLUTION

PostgreSQL 9.5 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 9.4 → 9.5
pg_authidStructural change
+ rolbypassrls− rolcatupdate
pg_classStructural change
+ relrowsecurity+ relforcerowsecurity
pg_descriptionStructural change
~ description: not_null: false → true
pg_extensionStructural change
~ extversion: not_null: false → true
pg_file_settingsCatalog added
+ sourcefile+ sourceline+ seqno+ name+ setting+ applied+ error
pg_pltemplateStructural change
~ tmplhandler: not_null: false → true~ tmpllibrary: not_null: false → true
pg_policiesCatalog added
+ schemaname+ tablename+ policyname+ roles+ cmd+ qual+ with_check
pg_policyCatalog added
+ oid+ polname+ polrelid+ polcmd+ polroles+ polqual+ polwithcheck
pg_procStructural change
+ protrftypes~ prosrc: not_null: false → true
pg_rolesStructural change
+ rolbypassrls− rolcatupdate
pg_seclabelStructural change
~ label: not_null: false → true~ provider: not_null: false → true
pg_shadowStructural change
+ usebypassrls− usecatupd
pg_shseclabelStructural change
~ label: not_null: false → true~ provider: not_null: false → true
pg_stat_sslCatalog added
+ pid+ ssl+ version+ cipher+ bits+ compression+ clientdn
pg_transformCatalog added
+ oid+ trftype+ trflang+ trffromsql+ trftosql
pg_triggerStructural change
~ tgargs: not_null: false → true
pg_userStructural change
+ usebypassrls− usecatupd