updating 4.7.4 to 5.0.0 fails: cannot ALTER TABLE "part_config_sub" because it has pending trigger events

[jw1u1]

Hi,

after upgrading from 4.2 to 4.7.4 an upgrade to 5.0.0 fails:

ALTER EXTENSION pg_partman UPDATE TO '5.0.0';
ERROR: cannot ALTER TABLE "part_config_sub" because it has pending trigger events

How to track that down?

[keithf4]

Ensure you have at least the 5.0.1 version of pg_partman installed. That should provide the proper split update files to avoid this error. See the upgrade guide documentation

https://github.com/pgpartman/pg_partman/releases/tag/v5.0.1
https://github.com/pgpartman/pg_partman/blob/v5.0.1/doc/pg_partman_5.0.1_upgrade.md

[jw1u1]

Thanks.
It's not obvious to continue on an error...

[keithf4]

It is always recommended to carefully read any upgrade documentation for any software you're using, especially when changing major versions. This is why I made this problem the first note on the 5.x CHANGELOG. I hope you were able to get the upgrade to go through.