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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
