Dimitrios Apostolou <jimis(at)gmx(dot)net> writes:
> I only got the "ERROR: deadlock detected" message once, with pg_restore
> compiled from master branch.
Oh, hmm ... do you recall just when on the master branch? I'm
wondering if it was before or after 14e87ffa5 (2024-11-08).
If it was after, then it might have been subject to the same
issue with not-null constraints that I ran into.
regards, tom lane