On 4/10/07, Tom Lane <[EMAIL PROTECTED]> wrote:
ISTM it'd be a good idea if it did, as "are there any incoming foreign keys" seems to be a question we constantly ask when solving update-performance problems, and there isn't any easy way to check for such.
Sure. We wrote a stored proc to do that and it could be really nice to have it by defaut in the table definition. Something like: Incoming foreign keys: "name_of_the_fkey" (column of this table) REFERENCED BY table(columns of the other table) could be nice. Not sure about the title of the section. Another problem is that this syntax is not based on valid SQL syntax. -- Guillaume ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend