Hi,

I'm using an R-Tree table in companion with a (rather large) table that contains all other data. Sometimes rows are deleted from the companion table due to foreign key constraints. Unfortunately the data in the R-Tree table remains untouched.

It seems that R-Tree tables do not support foreign keys. Is there perhaps another way that I can make sure that rows are deleted from the R-Tree table in response to deletes from the companion table?

Thanks in advance.

Kind regards,

Remco Poelstra

Perhaps you could set up a trigger to update the R-Tree when the companion table is updated.