[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Bacula-devel] pruning - using relational integrity


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@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/bacula-devel


This mailing list archive is a service of Copilot Consulting.