Re: [GENERAL] Inheritance fixing timeline? (Was Inherited FK Indexing)

2007-10-01 Thread Scott Ribe
Is this set to be fixed in any particular release? Depending on what you're doing, this may be overkill, but: I have child tables that not only need FK constraints, but also triggers and the functions called by the triggers. So instead of writing this over and over again, I eventually wrote a

Re: [GENERAL] Inheritance fixing timeline? (Was Inherited FK Indexing)

2007-10-01 Thread Alvaro Herrera
Webb Sprague escribió: Is it possible to have FK that spans into child tables? This is a well known (and documented, see [1]) deficiency. It's due to the current implementation of indices, which are bound to exactly one table, meaning they do return a position within the table,

[GENERAL] Inheritance fixing timeline? (Was Inherited FK Indexing)

2007-09-30 Thread Webb Sprague
Is it possible to have FK that spans into child tables? This is a well known (and documented, see [1]) deficiency. It's due to the current implementation of indices, which are bound to exactly one table, meaning they do return a position within the table, but cannot point to different