File tree Expand file tree Collapse file tree 1 file changed +10
-5
lines changed Expand file tree Collapse file tree 1 file changed +10
-5
lines changed Original file line number Diff line number Diff line change @@ -323,15 +323,20 @@ ERROR: permission denied for schema repack
323
323
pg_repack must be executed by a superuser.
324
324
325
325
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.
327
329
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.
329
332
330
333
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.
333
336
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.
335
340
336
341
337
342
Restrictions
You can’t perform that action at this time.
0 commit comments