Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> (This is on 8.2) What is happening here -- are we caching the plan for
> the FK check query?
Yeah, we've always done so. I'm a bit surprised though that it's
letting you drop the index --- isn't that index required for the FK
constraint? Exactly what is the constraint anyway?
regards, tom lane