Re: foreign key constraint, planner ignore index.

From: Andrew Nesheret <andrew(at)infinet(dot)ru>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: foreign key constraint, planner ignore index.
Date: 2007-12-20 12:56:07
Message-ID: 476A6667.5000807@infinet.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2007-12-20 13:26:28 Re: foreign key constraint, planner ignore index.
Previous Message Richard Huxton 2007-12-20 12:41:46 Re: foreign key constraint, planner ignore index.