Skip to content

Commit c395f72

Browse files
committed
Some docs clarification if you find a stray trigger
1 parent fbcd24b commit c395f72

File tree

1 file changed

+10
-5
lines changed

1 file changed

+10
-5
lines changed

doc/pg_repack.rst

Lines changed: 10 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -323,15 +323,20 @@ ERROR: permission denied for schema repack
323323
pg_repack must be executed by a superuser.
324324

325325
pg_repack: query failed: ERROR: trigger "z_repack_trigger" for relation "tbl" already exists
326-
The target table already has a trigger named ``z_repack_trigger``.
326+
The target table has already a trigger named ``z_repack_trigger``. This
327+
is probably caused by a previous failed attempt to run pg_repack on the
328+
table, which for some reason failed to clean up the temporary object.
327329

328-
Delete or rename the trigger.
330+
You can remove all the temporary objects by dropping and re-creating the
331+
extension: see the installation_ section for the details.
329332

330333
pg_repack: trigger conflicted for tbl
331-
The target table already has a trigger which follows
332-
``z_repack_trigger`` in alphabetical order.
334+
The target table has a trigger whose name follows ``z_repack_trigger``
335+
in alphabetical order.
333336

334-
Delete or rename the trigger.
337+
The ``z_repack_trigger`` should be the last BEFORE trigger to fire.
338+
Please rename your trigger to that it sorts alphabetically before
339+
pg_repack's one.
335340

336341

337342
Restrictions

0 commit comments

Comments
 (0)