> A common mistake, can't count how often I created this one... And not
> easy to find, because EXPLAIN won't explain triggers.
> I'm planning to create some kind of fk index wizard in pgAdmin3, which
> finds out about fks using columns that aren't covered by an appropriate
> index. Maybe this check could be performed (as a NOTICE) when the fk is
> created?
Weird - I'm planning the exact same thing for phpPgAdmin!
Great minds think alike :P
Chris