Re: foreign key constraint, planner ignore index. - Mailing list pgsql-general

From Andrew Nesheret
Subject Re: foreign key constraint, planner ignore index.
Date
Msg-id 476A6667.5000807@infinet.ru
Whole thread Raw
In response to Re: foreign key constraint, planner ignore index.  (Richard Huxton <dev@archonet.com>)
Responses Re: foreign key constraint, planner ignore index.
List pgsql-general
Richard Huxton wrote:
> Does the attached small script misbehave in the same way as your real
> data? From here it works fine when the fkey is ON ... RESTRICT.
>
> I'm right in thinking that your "nodes" fkey is RESTRICT on update and
> delete?
>
Yes, data is real and my my foreign key contraint is "restrict" (i'm
understand this is very important).

--
__________________________________
WBR, Andrew Nesheret ICQ:10518066


pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: foreign key constraint, planner ignore index.
Next
From: Richard Huxton
Date:
Subject: Re: foreign key constraint, planner ignore index.