diff options
| author | Bruce Momjian <bruce@momjian.us> | 2014-04-15 13:28:54 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2014-04-15 13:28:54 -0400 |
| commit | 4168c00a5d9c0c0c17cdfc902587b6d22ea1720f (patch) | |
| tree | 35a2de6d3fb312ed3d04f53cba4f2df9107f8121 /doc/src | |
| parent | c92c3d50d7fbe7391b5fc864b444346b2db29ffe (diff) | |
| download | postgresql-4168c00a5d9c0c0c17cdfc902587b6d22ea1720f.tar.gz postgresql-4168c00a5d9c0c0c17cdfc902587b6d22ea1720f.zip | |
psql: conditionally display oids and replication identity
In psql \d+, display oids only when they exist, and display replication
identity only when it is non-default. Also document the defaults for
replication identity for system and non-system tables. Update
regression output.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/alter_table.sgml | 4 | ||||
| -rw-r--r-- | doc/src/sgml/ref/psql-ref.sgml | 4 |
2 files changed, 6 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index e602ad34171..85705e9d34d 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -608,12 +608,14 @@ ALTER TABLE [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> <para> This form changes the information which is written to the write-ahead log to identify rows which are updated or deleted. This option has no effect - except when logical replication is in use. <literal>DEFAULT</> records the + except when logical replication is in use. <literal>DEFAULT</> + (the default for non-system tables) records the old values of the columns of the primary key, if any. <literal>USING INDEX</> records the old values of the columns covered by the named index, which must be unique, not partial, not deferrable, and include only columns marked <literal>NOT NULL</>. <literal>FULL</> records the old values of all columns in the row. <literal>NOTHING</> records no information about the old row. + (This is the default for system tables.) In all cases, no old values are logged unless at least one of the columns that would be logged differs between the old and new versions of the row. </para> diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index 85899d78fc5..0b91d45d804 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -951,7 +951,9 @@ testdb=> The command form <literal>\d+</literal> is identical, except that more information is displayed: any comments associated with the columns of the table are shown, as is the presence of OIDs in the - table, the view definition if the relation is a view. + table, the view definition if the relation is a view, a non-default + <link linkend="SQL-CREATETABLE-REPLICA-IDENTITY">replica + identity</link> setting. </para> <para> |