On Fri, 2002-03-08 at 08:26, Esposito, Paul wrote: > Hopefully I'm not stating the obvious, but depending on the database > being used, I would normally handle this using the database to cascade > these deletes. > > I know some of the databases torque supports don't support cascading > constraints, but many of them do. As a DBA, I prefer to keep rules such > as these in the database anyways, because it prevents RI problems. If > your using Oracle, Sybase or MS SQL Server, I could probably get you a > syntax snippet to cascade the deletes.
You're right -- the backend being used (PostgreSQL) does indeed support cascading deletes. Even better, Torque supports it as part of schaema generation (<foreign-key foreignTable="FOO" onDelete="cascade"/>). Many thanks!
msg06713/pgp00000.pgp
Description: PGP signature
