Re: Really strange foreign key constraint problem blocking delete

Adrian Klaver <adrian.klaver@aklaver.com> writes:
> SET enable_indexscan=off;

> EXPLAIN ANALYZE DELETE  query

> SET enable_indexscan=on;

Note that you'd probably best do this in a fresh session, since the
supposed problem is being tickled by a foreign-key check.  I think
the plans for those get cached, so if you'd already tried the same
case earlier in the session, changing enable_indexscan wouldn't
change the plan used.

            regards, tom lane