Re: pg_dump/restore failure (dependency?) on BF serinus

Andres Freund <andres(at)anarazel(dot)de> writes:
>> # Running: pg_restore --create -j2 -d postgres /home/bf/bf-build/serinus/HEAD/pgsql.build/testrun/pg_upgrade/002_pg_upgrade/data/tmp_test_KTss/regression.dump
>> pg_restore: error: could not execute query: ERROR: there is no unique constraint matching given keys for referenced table "pk"
>> Command was: ALTER TABLE fkpart5.fk
>> ADD CONSTRAINT fk_a_fkey FOREIGN KEY (a) REFERENCES fkpart5.pk(a);

> It's hard to tell without more logging, but the most likely explanation for
> this seems that somehow the primary key on fkpart5.pk hasn't yet been
> restored. However, looking at the pg_restore -v -l of the regression test
> database locally, the relevant dependencies look sane on a first glance.

This feels quite adjacent to my complaint here:

https://www.postgresql.org/message-id/2045026.1743801143%40sss.pgh.pa.us

though perhaps it's not exactly the same. I plan to start looking
into a fix for that tomorrow.

regards, tom lane