System Catalogs / Version comparison
What changed?
System Catalogs · PostgreSQL 8.2 → 8.3
Historical documentation for a PostgreSQL version that is no longer supported.
7 added · 0 removed · 14 changed · 0 coverage changes. These are changes between the pinned reference snapshots.
changedpg_am
--- 8.2 +++ 8.3 @@ -1,11 +1,12 @@ amname name amstrategies int2 amsupport int2 -amorderstrategy int2 +amcanorder bool amcanunique bool amcanmulticol bool amoptionalkey bool amindexnulls bool +amsearchnulls bool amstorage bool amclusterable bool aminsert regproc
changedpg_amop
--- 8.2 +++ 8.3 @@ -1,5 +1,7 @@ -amopclaid oid -amopsubtype oid +amopfamily oid +amoplefttype oid +amoprighttype oid amopstrategy int2 amopreqcheck bool amopopr oid +amopmethod oid
changedpg_amproc
--- 8.2 +++ 8.3 @@ -1,4 +1,5 @@ -amopclaid oid -amprocsubtype oid +amprocfamily oid +amproclefttype oid +amprocrighttype oid amprocnum int2 amproc regproc
changedpg_constraint
--- 8.2 +++ 8.3 @@ -11,5 +11,8 @@ confmatchtype char conkey int2[] confkey int2[] +conpfeqop oid[] +conppeqop oid[] +conffeqop oid[] conbin text consrc text
addedpg_enum
--- 8.2 +++ 8.3 @@ -0,0 +1,2 @@ +enumtypid oid +enumlabel name
changedpg_index
--- 8.2 +++ 8.3 @@ -5,7 +5,10 @@ indisprimary bool indisclustered bool indisvalid bool +indcheckxmin bool +indisready bool indkey int2vector indclass oidvector +indoption int2vector indexprs text indpred text
changedpg_language
--- 8.2 +++ 8.3 @@ -1,4 +1,5 @@ lanname name +lanowner oid lanispl bool lanpltrusted bool lanplcallfoid oid
changedpg_locks
--- 8.2 +++ 8.3 @@ -3,11 +3,12 @@ relation oid page integer tuple smallint +virtualxid text transactionid xid classid oid objid oid objsubid smallint -transaction xid +virtualtransaction text pid integer mode text granted boolean
changedpg_opclass
--- 8.2 +++ 8.3 @@ -1,7 +1,8 @@ -opcamid oid +opcmethod oid opcname name opcnamespace oid opcowner oid +opcfamily oid opcintype oid opcdefault bool opckeytype oid
changedpg_operator
--- 8.2 +++ 8.3 @@ -2,16 +2,13 @@ oprnamespace oid oprowner oid oprkind char +oprcanmerge bool oprcanhash bool oprleft oid oprright oid oprresult oid oprcom oid oprnegate oid -oprlsortop oid -oprrsortop oid -oprltcmpop oid -oprgtcmpop oid oprcode regproc oprrest regproc oprjoin regproc
addedpg_opfamily
--- 8.2 +++ 8.3 @@ -0,0 +1,4 @@ +opfmethod oid +opfname name +opfnamespace oid +opfowner oid
changedpg_pltemplate
--- 8.2 +++ 8.3 @@ -1,5 +1,6 @@ tmplname name tmpltrusted boolean +tmpldbacreate boolean tmplhandler text tmplvalidator text tmpllibrary text
changedpg_proc
--- 8.2 +++ 8.3 @@ -2,6 +2,8 @@ pronamespace oid proowner oid prolang oid +procost float4 +prorows float4 proisagg bool prosecdef bool proisstrict bool @@ -15,4 +17,5 @@ proargnames text[] prosrc text probin bytea +proconfig text[] proacl aclitem[]
changedpg_rewrite
--- 8.2 +++ 8.3 @@ -2,6 +2,7 @@ ev_class oid ev_attr int2 ev_type char +ev_enabled char is_instead bool ev_qual text ev_action text
changedpg_trigger
--- 8.2 +++ 8.3 @@ -2,10 +2,11 @@ tgname name tgfoid oid tgtype int2 -tgenabled bool +tgenabled char tgisconstraint bool tgconstrname name tgconstrrelid oid +tgconstraint oid tgdeferrable bool tginitdeferred bool tgnargs int2
addedpg_ts_config
--- 8.2 +++ 8.3 @@ -0,0 +1,4 @@ +cfgname name +cfgnamespace oid +cfgowner oid +cfgparser oid
addedpg_ts_config_map
--- 8.2 +++ 8.3 @@ -0,0 +1,4 @@ +mapcfg oid +maptokentype integer +mapseqno integer +mapdict oid
addedpg_ts_dict
--- 8.2 +++ 8.3 @@ -0,0 +1,5 @@ +dictname name +dictnamespace oid +dictowner oid +dicttemplate oid +dictinitoption text
addedpg_ts_parser
--- 8.2 +++ 8.3 @@ -0,0 +1,7 @@ +prsname name +prsnamespace oid +prsstart regproc +prstoken regproc +prsend regproc +prsheadline regproc +prslextype regproc
addedpg_ts_template
--- 8.2 +++ 8.3 @@ -0,0 +1,4 @@ +tmplname name +tmplnamespace oid +tmplinit regproc +tmpllexize regproc
changedpg_type
--- 8.2 +++ 8.3 @@ -8,10 +8,13 @@ typdelim char typrelid oid typelem oid +typarray oid typinput regproc typoutput regproc typreceive regproc typsend regproc +typmodin regproc +typmodout regproc typanalyze regproc typalign char typstorage char