>>>>> On Wed, 06 Jan 2010 11:37:18 +0100, Marek Simon said:
> 
> Hi,
> I do some experiments with bacula database and I found that there is no 
> foreign key constraint between jobmedia and job, jobmedia and media, job 
> and file and many similar logicaly connected tables. Why? Constraints 
> prevent arising void references (File with empty job, File with empty 
> filename, jobmedia record with empty job or media)
> I have bacula-dir version 2.4.4, postgres variant, and postgres 8.3, 
> default instalation.

Bacula inserts huge numbers of records into the File table during backups, so
any constraints on that table could be very bad for performance.

__Martin

------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev 
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users