SYSTEM CATALOGS / VERSION COMPARISON
What changed?
System Catalogs · PostgreSQL 9.2 → 9.3
Historical documentation for a PostgreSQL version that is no longer supported.
2 added · 0 removed · 33 changed · 0 coverage changes. These are changes in the pinned reference snapshots.
changedpg_am
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid amname name amstrategies int2 amsupport int2
changedpg_amop
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid amopfamily oid amoplefttype oid amoprighttype oid
changedpg_amproc
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid amprocfamily oid amproclefttype oid amprocrighttype oid
changedpg_attrdef
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid adrelid oid adnum int2 adbin pg_node_tree
changedpg_authid
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid rolname name rolsuper bool rolinherit bool
changedpg_cast
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid castsource oid casttarget oid castfunc oid
changedpg_class
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid relname name relnamespace oid reltype oid @@ -22,6 +23,8 @@ relhasrules bool relhastriggers bool relhassubclass bool +relispopulated bool relfrozenxid xid +relminmxid xid relacl aclitem[] reloptions text[]
changedpg_collation
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid collname name collnamespace oid collowner oid
changedpg_constraint
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid conname name connamespace oid contype char
changedpg_conversion
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid conname name connamespace oid conowner oid
changedpg_database
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid datname name datdba oid encoding int4 @@ -8,5 +9,6 @@ datconnlimit int4 datlastsysoid oid datfrozenxid xid +datminmxid xid dattablespace oid datacl aclitem[]
changedpg_default_acl
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid defaclrole oid defaclnamespace oid defaclobjtype char
changedpg_enum
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid enumtypid oid enumsortorder float4 enumlabel name
addedpg_event_trigger
--- 9.2 +++ 9.3 @@ -0,0 +1,6 @@ +evtname name +evtevent name +evtowner oid +evtfoid oid +evtenabled char +evttags text[]
changedpg_extension
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid extname name extowner oid extnamespace oid
changedpg_foreign_data_wrapper
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid fdwname name fdwowner oid fdwhandler oid
changedpg_foreign_server
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid srvname name srvowner oid srvfdw oid
changedpg_index
--- 9.2 +++ 9.3 @@ -9,6 +9,7 @@ indisvalid bool indcheckxmin bool indisready bool +indislive bool indkey int2vector indcollation oidvector indclass oidvector
changedpg_language
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid lanname name lanowner oid lanispl bool
changedpg_largeobject_metadata
--- 9.2 +++ 9.3 @@ -1,2 +1,3 @@ +oid oid lomowner oid lomacl aclitem[]
addedpg_matviews
--- 9.2 +++ 9.3 @@ -0,0 +1,7 @@ +schemaname name +matviewname name +matviewowner name +tablespace name +hasindexes boolean +ispopulated boolean +definition text
changedpg_namespace
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid nspname name nspowner oid nspacl aclitem[]
changedpg_opclass
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid opcmethod oid opcname name opcnamespace oid
changedpg_operator
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid oprname name oprnamespace oid oprowner oid
changedpg_opfamily
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid opfmethod oid opfname name opfnamespace oid
changedpg_proc
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid proname name pronamespace oid proowner oid
changedpg_rewrite
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid rulename name ev_class oid ev_attr int2
changedpg_tablespace
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid spcname name spcowner oid spcacl aclitem[]
changedpg_trigger
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid tgrelid oid tgname name tgfoid oid
changedpg_ts_config
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid cfgname name cfgnamespace oid cfgowner oid
changedpg_ts_dict
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid dictname name dictnamespace oid dictowner oid
changedpg_ts_parser
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid prsname name prsnamespace oid prsstart regproc
changedpg_ts_template
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid tmplname name tmplnamespace oid tmplinit regproc
changedpg_type
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid typname name typnamespace oid typowner oid
changedpg_user_mapping
--- 9.2 +++ 9.3 @@ -1,3 +1,4 @@ +oid oid umuser oid umserver oid umoptions text[]