Skip to content

Commit 52e7761

Browse files
committed
Fixed doc formatting and dropped stale diagnostics entries
1 parent fb07fad commit 52e7761

File tree

1 file changed

+10
-20
lines changed

1 file changed

+10
-20
lines changed

doc/pg_repack.rst

Lines changed: 10 additions & 20 deletions
Original file line numberDiff line numberDiff line change
@@ -119,7 +119,7 @@ Options:
119119
-a, --all repack all databases
120120
-t, --table=TABLE repack specific table only
121121
-s, --tablespace=TBLSPC move repacked tables to a new tablespace
122-
-S, --moveidx move repacked indexes to TBLSPC too
122+
-S, --moveidx move repacked indexes to *TBLSPC* too
123123
-o, --order-by=COLUMNS order by columns instead of cluster keys
124124
-n, --no-order do vacuum full instead of cluster
125125
-j, --jobs Use this many parallel jobs for each table
@@ -293,13 +293,13 @@ database where the error occured and then load
293293

294294
.. class:: diag
295295

296-
pg_repack: repack database "template1" ... skipped: pg_repack is not installed in the database
297-
pg_repack is not installed in the database when ``--all`` option is
296+
INFO: database "db" skipped: pg_repack VER is not installed in the database
297+
pg_repack is not installed in the database when the ``--all`` option is
298298
specified.
299299

300300
Create the pg_repack extension in the database.
301301

302-
ERROR: pg_repack is not installed
302+
ERROR: pg_repack VER is not installed in the database
303303
pg_repack is not installed in the database specified by ``--dbname``.
304304

305305
Create the pg_repack extension in the database.
@@ -326,22 +326,11 @@ ERROR: relation "table" must have a primary key or not-null unique keys
326326

327327
Define a PRIMARY KEY or a UNIQUE constraint on the table.
328328

329-
ERROR: relation "table" has no cluster key
330-
The target table doesn't have CLUSTER KEY.
331-
332-
Define a CLUSTER KEY on the table, via ALTER TABLE CLUSTER ON, or use
333-
one of the --no-order or --order-by modes.
334-
335329
ERROR: query failed: ERROR: column "col" does not exist
336330
The target table doesn't have columns specified by ``--order-by`` option.
337331

338332
Specify existing columns.
339333

340-
ERROR: permission denied for schema repack
341-
Permission error.
342-
343-
pg_repack must be executed by a superuser.
344-
345334
WARNING: the table "tbl" has already a trigger called z_repack_trigger
346335
The trigger was probably installed during a previous attempt to run
347336
pg_repack on the table which was interrupted and for some reason failed
@@ -416,13 +405,14 @@ Releases
416405

417406
* pg_repack 1.2
418407

419-
* Added --tablespace and --moveidx options to perform online SET TABLESPACE.
420-
* Added --jobs option for parallel operation.
421-
* Don't require --no-order to perform a VACUUM FULL on non-clustered tables
422-
(pg_repack issue #6).
423-
* More helpful error messages.
408+
* Added ``--tablespace`` and ``--moveidx`` options to perform online
409+
SET TABLESPACE.
410+
* Added ``--jobs`` option for parallel operation.
411+
* Don't require ``--no-order`` to perform a VACUUM FULL on non-clustered
412+
tables (pg_repack issue #6).
424413
* Bugfix: correctly handle key indexes with options such as DESC, NULL
425414
FIRST/LAST, COLLATE (pg_repack issue #3).
415+
* More helpful program output and error messages.
426416

427417
* pg_repack 1.1.8
428418

0 commit comments

Comments
 (0)