What changed?

9.0 → 9.1
+ amcanorderbyop  boolean
+ ampredlocks  boolean
+ ambuildempty  regproc
- amindexnulls  boolean

9.0 → 9.1
+ amoppurpose  "char"
+ amopsortfamily  oid

9.0 → 9.1
~ adbin  text → pg_node_tree

9.0 → 9.1
+ attcollation  oid

9.0 → 9.1
+ rolreplication  boolean

--- 9.0
+++ 9.1
@@ -0,0 +1,8 @@
+name  name
+version  text
+installed  boolean
+superuser  boolean
+relocatable  boolean
+schema  name
+requires  name[]
+comment  text

--- 9.0
+++ 9.1
@@ -0,0 +1,4 @@
+name  name
+default_version  text
+installed_version  text
+comment  text

9.0 → 9.1
+ relpersistence  "char"
- relistemp  boolean
- relhasexclusion  boolean

--- 9.0
+++ 9.1
@@ -0,0 +1,6 @@
+collname  name
+collnamespace  oid
+collowner  oid
+collencoding  integer
+collcollate  name
+collctype  name

9.0 → 9.1
+ convalidated  boolean
~ conbin  text → pg_node_tree

--- 9.0
+++ 9.1
@@ -1,4 +1,4 @@
-(relation) The catalog pg_conversion describes the available encoding conversion procedures. See CREATE CONVERSION for more information.
+(relation) The catalog pg_conversion describes encoding conversion procedures. See CREATE CONVERSION for more information.
 conname: Conversion name (unique within a namespace)
 connamespace: The OID of the namespace that contains this conversion
 conowner: Owner of the conversion

9.0 → 9.1
+ enumsortorder  real

--- 9.0
+++ 9.1
@@ -0,0 +1,7 @@
+extname  name
+extowner  oid
+extnamespace  oid
+extrelocatable  boolean
+extversion  text
+extconfig  oid[]
+extcondition  text[]

9.0 → 9.1
+ fdwhandler  oid

--- 9.0
+++ 9.1
@@ -1,7 +1,7 @@
-(relation) The catalog pg_foreign_server stores foreign server definitions. A foreign server describes the connection to a remote server, managing external data. Foreign servers are accessed via foreign-data wrappers.
+(relation) The catalog pg_foreign_server stores foreign server definitions. A foreign server describes a source of external data, such as a remote server. Foreign servers are accessed via foreign-data wrappers.
 srvname: Name of the foreign server
 srvowner: Owner of the foreign server
-srvfdw: The OID of the foreign-data wrapper of this foreign server
+srvfdw: OID of the foreign-data wrapper of this foreign server
 srvtype: Type of the server (optional)
 srvversion: Version of the server (optional)
 srvacl: Access privileges; see GRANT and REVOKE for details

--- 9.0
+++ 9.1
@@ -0,0 +1,3 @@
+ftrelid  oid
+ftserver  oid
+ftoptions  text[]

9.0 → 9.1
+ indisexclusion  boolean
+ indcollation  oidvector
~ indexprs  text → pg_node_tree
~ indpred  text → pg_node_tree

--- 9.0
+++ 9.1
@@ -1,4 +1,4 @@
-(relation) The view pg_locks provides access to information about the locks held by open transactions within the database server. See Chapter 13 for more discussion of locking. pg_locks contains one row per active lockable object, requested lock mode, and relevant transaction. Thus, the same lockable object might appear many times, if multiple transactions are holding or waiting for locks on it. However, an object that currently has no locks on it will not appear at all. There are several distinct types of lockable objects: whole relations (e.g., tables), individual pages of relations, individual tuples of relations, transaction IDs (both virtual and permanent IDs), and general database objects (identified by class OID and object OID, in the same way as in pg_description or pg_depend). Also, the right to extend a relation is represented as a separate lockable object.
+(relation) The view pg_locks provides access to information about the locks held by open transactions within the database server. See Chapter 13 for more discussion of locking. pg_locks contains one row per active lockable object, requested lock mode, and relevant transaction. Thus, the same lockable object might appear many times, if multiple transactions are holding or waiting for locks on it. However, an object that currently has no locks on it will not appear at all. There are several distinct types of lockable objects: whole relations (e.g., tables), individual pages of relations, individual tuples of relations, transaction IDs (both virtual and permanent IDs), and general database objects (identified by class OID and object OID, in the same way as in pg_description or pg_depend). Also, the right to extend a relation is represented as a separate lockable object. Also, "advisory" locks can be taken on numbers that have user-defined meanings.
 locktype: Type of the lockable object: relation, extend, page, tuple, transactionid, virtualxid, object, userlock, or advisory
 database: OID of the database in which the object exists, or zero if the object is a shared object, or null if the object is a transaction ID
 relation: OID of the relation, or null if the object is not a relation or part of a relation
@@ -8,8 +8,8 @@
 transactionid: ID of a transaction, or null if the object is not a transaction ID
 classid: OID of the system catalog containing the object, or null if the object is not a general database object
 objid: OID of the object within its system catalog, or null if the object is not a general database object
-objsubid: For a table column, this is the column number (the classid and objid refer to the table itself). For all other object types, this column is zero. Null if the object is not a general database object
+objsubid: Column number targeted by the lock (the classid and objid refer to the table itself), or zero if the target is some other general database object, or null if the target is not a general database object
 virtualtransaction: Virtual ID of the transaction that is holding or awaiting this lock
-pid: Process ID of the server process holding or awaiting this lock. Null if the lock is held by a prepared transaction.
-mode: Name of the lock mode held or desired by this process (see Section 13.3.1)
+pid: Process ID of the server process holding or awaiting this lock, or null if the lock is held by a prepared transaction
+mode: Name of the lock mode held or desired by this process (see Section 13.3.1 and Section 13.2.3)
 granted: True if lock is held, false if lock is awaited

--- 9.0
+++ 9.1
@@ -6,4 +6,4 @@
 tmplinline: Name of anonymous-block handler function, or null if none
 tmplvalidator: Name of validator function, or null if none
 tmpllibrary: Path of shared library that implements language
-tmplacl: Access privileges for template (not yet used)
+tmplacl: Access privileges for template (not actually used)

9.0 → 9.1
~ proargdefaults  text → pg_node_tree

9.0 → 9.1
~ ev_action  text → pg_node_tree
~ ev_qual  text → pg_node_tree

9.0 → 9.1
+ rolreplication  boolean

--- 9.0
+++ 9.1
@@ -0,0 +1,5 @@
+objoid  oid
+classoid  oid
+objsubid  integer
+provider  text
+label  text

--- 9.0
+++ 9.1
@@ -0,0 +1,8 @@
+objoid  oid
+classoid  oid
+objsubid  integer
+objtype  text
+objnamespace  oid
+objname  text
+provider  text
+label  text

--- 9.0
+++ 9.1
@@ -5,7 +5,7 @@
 category: Logical group of the parameter
 short_desc: A brief description of the parameter
 extra_desc: Additional, more detailed, description of the parameter
-context: Context required to set the parameter's value
+context: Context required to set the parameter's value (see below)
 vartype: Parameter type (bool, enum, integer, real, or string)
 source: Source of the current parameter value
 min_val: Minimum allowed value of the parameter (null for non-numeric values)

9.0 → 9.1
+ userepl  (reported by the 9.1.24 server; the manual does not list it)

9.0 → 9.1
+ client_hostname  text

9.0 → 9.1
+ vacuum_count  bigint
+ autovacuum_count  bigint
+ analyze_count  bigint
+ autoanalyze_count  bigint

9.0 → 9.1
+ buffers_backend_fsync  bigint
+ stats_reset  timestamp with time zone

9.0 → 9.1
+ conflicts  bigint
+ stats_reset  timestamp with time zone

--- 9.0
+++ 9.1
@@ -0,0 +1,7 @@
+datid  oid
+datname  name
+confl_tablespace  bigint
+confl_lock  bigint
+confl_snapshot  bigint
+confl_bufferpin  bigint
+confl_deadlock  bigint

--- 9.0
+++ 9.1
@@ -0,0 +1,15 @@
+procpid  integer
+usesysid  oid
+usename  name
+application_name  text
+client_addr  inet
+client_hostname  text
+client_port  integer
+backend_start  timestamp with time zone
+state  text
+sent_location  text
+write_location  text
+flush_location  text
+replay_location  text
+sync_priority  integer
+sync_state  text

9.0 → 9.1
+ vacuum_count  bigint
+ autovacuum_count  bigint
+ analyze_count  bigint
+ autoanalyze_count  bigint

9.0 → 9.1
+ vacuum_count  bigint
+ autovacuum_count  bigint
+ analyze_count  bigint
+ autoanalyze_count  bigint

--- 9.0
+++ 9.1
@@ -0,0 +1,11 @@
+relid  oid
+schemaname  name
+relname  name
+seq_scan  bigint
+seq_tup_read  bigint
+idx_scan  bigint
+idx_tup_fetch  bigint
+n_tup_ins  bigint
+n_tup_upd  bigint
+n_tup_del  bigint
+n_tup_hot_upd  bigint

--- 9.0
+++ 9.1
@@ -0,0 +1,11 @@
+relid  oid
+schemaname  name
+relname  name
+seq_scan  bigint
+seq_tup_read  bigint
+idx_scan  bigint
+idx_tup_fetch  bigint
+n_tup_ins  bigint
+n_tup_upd  bigint
+n_tup_del  bigint
+n_tup_hot_upd  bigint

--- 9.0
+++ 9.1
@@ -0,0 +1,6 @@
+funcid  oid
+schemaname  name
+funcname  name
+calls  bigint
+total_time  bigint
+self_time  bigint

--- 9.0
+++ 9.1
@@ -0,0 +1,11 @@
+relid  oid
+schemaname  name
+relname  name
+seq_scan  bigint
+seq_tup_read  bigint
+idx_scan  bigint
+idx_tup_fetch  bigint
+n_tup_ins  bigint
+n_tup_upd  bigint
+n_tup_del  bigint
+n_tup_hot_upd  bigint

--- 9.0
+++ 9.1
@@ -4,7 +4,7 @@
 stainherit: If true, the stats include inheritance child columns, not just the values in the specified relation
 stanullfrac: The fraction of the column's entries that are null
 stawidth: The average stored width, in bytes, of nonnull entries
-stadistinct: The number of distinct nonnull data values in the column. A value greater than zero is the actual number of distinct values. A value less than zero is the negative of a multiplier for the number of rows in the table; for example, a column in which values appear about twice on the average could be represented by stadistinct = -0.5. A zero value means the number of distinct values is unknown.
+stadistinct: The number of distinct nonnull data values in the column. A value greater than zero is the actual number of distinct values. A value less than zero is the negative of a multiplier for the number of rows in the table; for example, a column in which about 80% of the values are nonnull and each nonnull value appears about twice on average could be represented by stadistinct = -0.4. A zero value means the number of distinct values is unknown.
 stakind1: A code number indicating the kind of statistics stored in the Nth "slot" of the pg_statistic row.
 stakind2: A code number indicating the kind of statistics stored in the Nth "slot" of the pg_statistic row.
 stakind3: A code number indicating the kind of statistics stored in the Nth "slot" of the pg_statistic row.

--- 9.0
+++ 9.1
@@ -1,4 +1,4 @@
-(relation) The view pg_timezone_names provides a list of time zone names that are recognized by SET TIMEZONE, along with their associated abbreviations, UTC offsets, and daylight-savings status. Unlike the abbreviations shown in pg_timezone_abbrevs, many of these names imply a set of daylight-savings transition date rules. Therefore, the associated information changes across local DST boundaries. The displayed information is computed based on the current value of CURRENT_TIMESTAMP.
+(relation) The view pg_timezone_names provides a list of time zone names that are recognized by SET TIMEZONE, along with their associated abbreviations, UTC offsets, and daylight-savings status. (Technically, PostgreSQL uses UT1 rather than UTC because leap seconds are not handled.) Unlike the abbreviations shown in pg_timezone_abbrevs, many of these names imply a set of daylight-savings transition date rules. Therefore, the associated information changes across local DST boundaries. The displayed information is computed based on the current value of CURRENT_TIMESTAMP.
 name: Time zone name
 abbrev: Time zone abbreviation
 utc_offset: Offset from UTC (positive means east of Greenwich)

9.0 → 9.1
~ tgqual  text → pg_node_tree

9.0 → 9.1
+ typcollation  oid
~ typdefaultbin  text → pg_node_tree

9.0 → 9.1
+ userepl  (reported by the 9.1.24 server; the manual does not list it)