System Catalogs / Version comparison
What changed?
System Catalogs · PostgreSQL 8.3 → 8.4
Historical documentation for a PostgreSQL version that is no longer supported.
5 added · 1 removed · 11 changed · 4 reworded · 0 with columns not listed. These are changes between the pinned reference snapshots. “Changed” means columns, their types, their order or a measured attribute such as NOT NULL; “reworded” means only the manual's descriptions.
changedpg_am
8.3 → 8.4 + amcanbackward boolean + amkeytype oid + amgetbitmap regproc - amgetmulti regproc
changedpg_amop
8.3 → 8.4 - amopreqcheck boolean
changedpg_attribute
8.3 → 8.4 + attacl aclitem[]
rewordedpg_authid
--- 8.3 +++ 8.4 @@ -1,4 +1,4 @@ -(relation) The catalog pg_authid contains information about database authorization identifiers (roles). A role subsumes the concepts of "users" and "groups". A user is essentially just a role with the rolcanlogin flag set. Any role (with or without rolcanlogin) can have other roles as members; see pg_auth_members. Since this catalog contains passwords, it must not be publicly readable. pg_roles is a publicly readable view on pg_authid that blanks out the password field. Chapter 19 contains detailed information about user and privilege management. Because user identities are cluster-wide, pg_authid is shared across all databases of a cluster: there is only one copy of pg_authid per cluster, not one per database. +(relation) The catalog pg_authid contains information about database authorization identifiers (roles). A role subsumes the concepts of "users" and "groups". A user is essentially just a role with the rolcanlogin flag set. Any role (with or without rolcanlogin) can have other roles as members; see pg_auth_members. Since this catalog contains passwords, it must not be publicly readable. pg_roles is a publicly readable view on pg_authid that blanks out the password field. Chapter 20 contains detailed information about user and privilege management. Because user identities are cluster-wide, pg_authid is shared across all databases of a cluster: there is only one copy of pg_authid per cluster, not one per database. rolname: Role name rolsuper: Role has superuser privileges rolinherit: Role automatically inherits privileges of roles it is a member of
removedpg_autovacuum
--- 8.3 +++ 8.4 @@ -1,10 +0,0 @@ -vacrelid oid -enabled boolean -vac_base_thresh integer -vac_scale_factor real -anl_base_thresh integer -anl_scale_factor real -vac_cost_delay integer -vac_cost_limit integer -freeze_min_age integer -freeze_max_age integer
changedpg_cast
8.3 → 8.4 + castmethod "char"
changedpg_class
8.3 → 8.4 + relistemp boolean + relhastriggers boolean - reltriggers smallint - relukeys smallint - relfkeys smallint - relrefs smallint
changedpg_constraint
8.3 → 8.4 + conislocal boolean + coninhcount integer
changedpg_database
8.3 → 8.4 + datcollate name + datctype name
addedpg_foreign_data_wrapper
--- 8.3 +++ 8.4 @@ -0,0 +1,5 @@ +fdwname name +fdwowner oid +fdwvalidator oid +fdwacl aclitem[] +fdwoptions text[]
addedpg_foreign_server
--- 8.3 +++ 8.4 @@ -0,0 +1,7 @@ +srvname name +srvowner oid +srvfdw oid +srvtype text +srvversion text +srvacl aclitem[] +srvoptions text[]
changedpg_proc
8.3 → 8.4 + provariadic oid + proiswindow boolean + pronargdefaults smallint + proargdefaults text
rewordedpg_rewrite
--- 8.3 +++ 8.4 @@ -1,7 +1,7 @@ (relation) The catalog pg_rewrite stores rewrite rules for tables and views. rulename: Rule name ev_class: The table this rule is for -ev_attr: The column this rule is for (currently, always zero to indicate the whole table) +ev_attr: The column this rule is for (currently, always -1 to indicate the whole table) ev_type: Event type that the rule is for: 1 = SELECT, 2 = UPDATE, 3 = INSERT, 4 = DELETE ev_enabled: Controls in which session_replication_role modes the rule fires. O = rule fires in "origin" and "local" modes, D = rule is disabled, R = rule fires in "replica" mode, A = rule fires always. is_instead: True if the rule is an INSTEAD rule
changedpg_settings
8.3 → 8.4 + enumvals text[] + boot_val text + reset_val text + sourcefile text + sourceline integer
changedpg_shdepend
8.3 → 8.4 + objsubid integer
addedpg_stat_user_functions
This manual names the view without listing its columns.
rewordedpg_stats
--- 8.3 +++ 8.4 @@ -5,7 +5,7 @@ null_frac: Fraction of column entries that are null avg_width: Average width in bytes of column's entries n_distinct: If greater than zero, the estimated number of distinct values in the column. If less than zero, the negative of the number of distinct values divided by the number of rows. (The negated form is used when ANALYZE believes that the number of distinct values is likely to increase as the table grows; the positive form is used when the column seems to have a fixed number of possible values.) For example, -1 indicates a unique column in which the number of distinct values is the same as the number of rows -most_common_vals: A list of the most common values in the column. (NULL if no values seem to be more common than any others.) -most_common_freqs: A list of the frequencies of the most common values, i.e., number of occurrences of each divided by total number of rows. (NULL when most_common_vals is.) +most_common_vals: A list of the most common values in the column. (NULL if no values seem to be more common than any others.) For some datatypes such as tsvector, this is a list of the most common element values rather than values of the type itself. +most_common_freqs: A list of the frequencies of the most common values or elements, i.e., number of occurrences of each divided by total number of rows. (NULL when most_common_vals is.) For some datatypes such as tsvector, it can also store some additional information, making it longer than the most_common_vals array. histogram_bounds: A list of values that divide the column's values into groups of approximately equal population. The values in most_common_vals, if present, are omitted from this histogram calculation. (This column is NULL if the column data type does not have a < operator or if the most_common_vals list accounts for the entire population.) correlation: Statistical correlation between physical row ordering and logical ordering of the column values. This ranges from -1 to +1. When the value is near -1 or +1, an index scan on the column will be estimated to be cheaper than when it is near zero, due to reduction of random access to the disk. (This column is NULL if the column data type does not have a < operator.)
rewordedpg_tables
--- 8.3 +++ 8.4 @@ -4,5 +4,5 @@ tableowner: Name of table's owner tablespace: Name of tablespace containing table (NULL if default for database) hasindexes: true if table has (or recently had) any indexes -hasrules: true if table has rules -hastriggers: true if table has triggers +hasrules: true if table has (or once had) rules +hastriggers: true if table has (or once had) triggers
changedpg_type
8.3 → 8.4 + typcategory "char" + typispreferred boolean
addedpg_user_mapping
--- 8.3 +++ 8.4 @@ -0,0 +1,3 @@ +umuser oid +umserver oid +umoptions text[]
addedpg_user_mappings
--- 8.3 +++ 8.4 @@ -0,0 +1,6 @@ +umid oid +srvid oid +srvname text +umuser oid +usename name +umoptions text[]