On 2019-Jul-12, Tom Lane wrote:
> The OP already found the best method to get out of this, which is to
> drop and re-add the FK constraint. Adding the constraint will force
> a full verification scan, which is what you need here since there's
> no information available about which checks were missed.
Maybe it would make sense to be able to mark the FK as not validated, so
that you can apply ALTER CONSTRAINT ... VALIDATE. Seems better than
DROP + ADD.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services