pg_dump: warning: there are circular foreign-key constraints

[floh116]

After Updating from postgres extension version 5.1 to version 5.2 (also install on new installation with 5.2 from the start) pg_dump (and pg_dumpall) is printing out a warning:

[root@postgresdb02 home]# sudo -u postgres pg_dump repmgr pg_dump: warning: there are circular foreign-key constraints on this table: pg_dump: nodes pg_dump: You might not be able to restore the dump without using --disable-triggers or temporarily dropping the constraints. pg_dump: Consider using a full dump instead of a --data-only dump to avoid this problem.

-- PostgreSQL database dump

-- Dumped from database version 12.5 .......

It seems this warnings came in with https://github.com/2ndQuadrant/repmgr/commit/d62743ddf46d09303924b017d3910dd596ef428e

[loop-evgeny]

Still happening with repmgr 5.3.3, PostgreSQL 15.2. In fact, on the primary I get:

pg_dump: warning: there are circular foreign-key constraints on this table:

... with no tables listed! On the primary it lists the table "node", as in the original issue description.