-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Rich Shepard wrote: > I use triggers to enforce referential integrity with foreign keys. Is this > not a suitable approach for what you want to do?
Bringing things full circle, that is exactly what the genfkey functionality does. It parses the foreign key constraints and generates a set of triggers to ensure they are enforced. It used to be a separate program until it was moved into the shell and exposed as a command (in February of this year). You can rerun the command as often as you want - - it will delete the existing triggers (their name has a predictable prefix) and generate a new set. Unfortunately because it is part of the shell, that is the only way to access it. For many it is sufficient as you can load your database with the shell, run genfkey and then quit. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkpj7xYACgkQmOOfHg372QSCuwCeIp5DZQ4fa+ePu0Ht59Da5CxP YvEAn1in4FTRtmAj3UXCnuSC/oZ9VHjR =lOze -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
