Postgres Pro
Downloads
Home   >   mailing lists

Re: FK plans cached? Known bug? - Mailing list pgsql-bugs

From Tom Lane
Subject Re: FK plans cached? Known bug?
Date
Msg-id 205.1179510286@sss.pgh.pa.us
Whole thread Raw
In response to FK plans cached? Known bug?  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: FK plans cached? Known bug?  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-bugs
Tree view 
Alvaro Herrera <alvherre@commandprompt.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

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: FK plans cached? Known bug?
Next
From: Alvaro Herrera
Date:
Subject: Re: FK plans cached? Known bug?