System Catalogs / Version comparison
What changed?
System Catalogs · PostgreSQL 8.1 → 8.2
Historical documentation for a PostgreSQL version that is no longer supported.
5 added · 0 removed · 6 changed · 0 coverage changes. These are changes between the pinned reference snapshots.
changedpg_am
--- 8.1 +++ 8.2 @@ -6,7 +6,8 @@ amcanmulticol bool amoptionalkey bool amindexnulls bool -amconcurrent bool +amstorage bool +amclusterable bool aminsert regproc ambeginscan regproc amgettuple regproc @@ -19,3 +20,4 @@ ambulkdelete regproc amvacuumcleanup regproc amcostestimate regproc +amoptions regproc
changedpg_autovacuum
--- 8.1 +++ 8.2 @@ -6,3 +6,5 @@ anl_scale_factor float4 vac_cost_delay integer vac_cost_limit integer +freeze_min_age integer +freeze_max_age integer
changedpg_class
--- 8.1 +++ 8.2 @@ -22,4 +22,6 @@ relhaspkey bool relhasrules bool relhassubclass bool +relfrozenxid xid relacl aclitem[] +reloptions text[]
addedpg_cursors
--- 8.1 +++ 8.2 @@ -0,0 +1,6 @@ +name text +statement text +is_holdable boolean +is_binary boolean +is_scrollable boolean +creation_time timestamptz
changedpg_database
--- 8.1 +++ 8.2 @@ -5,7 +5,6 @@ datallowconn bool datconnlimit int4 datlastsysoid oid -datvacuumxid xid datfrozenxid xid dattablespace oid datconfig text[]
changedpg_index
--- 8.1 +++ 8.2 @@ -4,6 +4,7 @@ indisunique bool indisprimary bool indisclustered bool +indisvalid bool indkey int2vector indclass oidvector indexprs text
addedpg_prepared_statements
--- 8.1 +++ 8.2 @@ -0,0 +1,5 @@ +name text +statement text +prepare_time timestamptz +parameter_types regtype[] +from_sql boolean
changedpg_settings
--- 8.1 +++ 8.2 @@ -1,5 +1,6 @@ name text setting text +unit text category text short_desc text extra_desc text
addedpg_shdescription
--- 8.1 +++ 8.2 @@ -0,0 +1,3 @@ +objoid oid +classoid oid +description text
addedpg_timezone_abbrevs
--- 8.1 +++ 8.2 @@ -0,0 +1,3 @@ +abbrev text +utc_offset interval +is_dst boolean
addedpg_timezone_names
--- 8.1 +++ 8.2 @@ -0,0 +1,4 @@ +name text +abbrev text +utc_offset interval +is_dst boolean