Kern Sibbald wrote: > On Tuesday 12 February 2008 16.00:22 Dan Langille wrote: >> I'm a big fan of relational integrity. If you delete a job from the >> Job table, everything >> should magically disappear from the database. > > That is the way it works, only Bacula explicitly maintains the relational > integrity itself rather than relying on the SQL engine to do it. > >> This approach should greatly simplify the pruning. > > Unfortunately not all database support relational integrity ...
We only deal with SQLite, PostgreSQL and MySQL. Is SQLite being dropped? If so, both MySQL and PostgreSQL do RI. -- Dan Langille - http://www.langille.org/ BSDCan - The Technical BSD Conference: http://www.bsdcan.org/ PGCon - The PostgreSQL Conference: http://www.pgcon.org/ ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
