diff options
| author | Peter Eisentraut <peter@eisentraut.org> | 2021-09-28 15:26:25 +0200 |
|---|---|---|
| committer | Peter Eisentraut <peter@eisentraut.org> | 2021-09-28 15:26:25 +0200 |
| commit | c3b011d9918100c6ec2d72297fb51635bce70e80 (patch) | |
| tree | 4d45773b7c550835a17a3b9ccf6c37344a3d68ba /doc/src | |
| parent | 7d1aa6bf1c27bf7438179db446f7d1e72ae093d0 (diff) | |
| download | postgresql-c3b011d9918100c6ec2d72297fb51635bce70e80.tar.gz postgresql-c3b011d9918100c6ec2d72297fb51635bce70e80.zip | |
Support amcheck of sequences
Sequences were left out of the list of relation kinds that
verify_heapam knew how to check, though it is fairly trivial to allow
them. Doing that, and while at it, updating pg_amcheck to include
sequences in relations matched by table and relation patterns.
Author: Mark Dilger <mark.dilger@enterprisedb.com>
Discussion: https://www.postgresql.org/message-id/flat/81ad4757-92c1-4aa3-7bee-f609544837e3%40enterprisedb.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/amcheck.sgml | 8 | ||||
| -rw-r--r-- | doc/src/sgml/ref/pg_amcheck.sgml | 15 |
2 files changed, 13 insertions, 10 deletions
diff --git a/doc/src/sgml/amcheck.sgml b/doc/src/sgml/amcheck.sgml index c570690b59c..11d1eb5af23 100644 --- a/doc/src/sgml/amcheck.sgml +++ b/doc/src/sgml/amcheck.sgml @@ -220,10 +220,10 @@ SET client_min_messages = DEBUG1; </term> <listitem> <para> - Checks a table for structural corruption, where pages in the relation - contain data that is invalidly formatted, and for logical corruption, - where pages are structurally valid but inconsistent with the rest of the - database cluster. + Checks a table, sequence, or materialized view for structural corruption, + where pages in the relation contain data that is invalidly formatted, and + for logical corruption, where pages are structurally valid but + inconsistent with the rest of the database cluster. </para> <para> The following optional arguments are recognized: diff --git a/doc/src/sgml/ref/pg_amcheck.sgml b/doc/src/sgml/ref/pg_amcheck.sgml index d00c48d0e79..1fd0ecd9114 100644 --- a/doc/src/sgml/ref/pg_amcheck.sgml +++ b/doc/src/sgml/ref/pg_amcheck.sgml @@ -41,8 +41,9 @@ PostgreSQL documentation </para> <para> - Only table relations and btree indexes are currently supported. Other - relation types are silently skipped. + Only ordinary and toast table relations, materialized views, sequences, and + btree indexes are currently supported. Other relation types are silently + skipped. </para> <para> @@ -124,7 +125,7 @@ PostgreSQL documentation </para> <para> This is similar to the <option>--relation</option> option, except that - it applies only to indexes, not tables. + it applies only to indexes, not to other relation types. </para> </listitem> </varlistentry> @@ -140,7 +141,7 @@ PostgreSQL documentation </para> <para> This is similar to the <option>--exclude-relation</option> option, - except that it applies only to indexes, not tables. + except that it applies only to indexes, not other relation types. </para> </listitem> </varlistentry> @@ -236,7 +237,8 @@ PostgreSQL documentation </para> <para> This is similar to the <option>--relation</option> option, except that - it applies only to tables, not indexes. + it applies only to tables, materialized views, and sequences, not to + indexes. </para> </listitem> </varlistentry> @@ -252,7 +254,8 @@ PostgreSQL documentation </para> <para> This is similar to the <option>--exclude-relation</option> option, - except that it applies only to tables, not indexes. + except that it applies only to tables, materialized views, and + sequences, not to indexes. </para> </listitem> </varlistentry> |