Laurette, > How is this possible? I've tried to reproduce this, but haven't been able > to yet. This has happened to use several times.
Question 1: Can you experimentally create a record in table1, a matching record in table 2, and then delete the record in table1? It's possible that your "ON DELETE CASCADE" trigger got wiped out somehow. -- -Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
