[geeks] MySQL question

[Phil Stracchino]

On Tue, May 25, 2004 at 12:37:04AM -0400, Patrick Giagnocavo +1.717.201.3366 wrote:
> I think I found it.  MySQL does not have true foreign key constraints.
> PG does.  Thus, if you enable PG's FK constraints it slows down the PG
> side. The bacula datamodel for other databases does not use foreign
> keys.
> 
> this:
> 
> http://sourceforge.net/mailarchive/forum.php?thread_id=4685884&forum_id=8650
> 
> and this:
> 
> http://sourceforge.net/mailarchive/forum.php?thread_id=4685889&forum_id=8650
> 
> Appear to be the threads that cover it.

Yup, that looks like it.


> Hm well I haven't looked over the datamodel yet.  If you have a link
> to just that file it wold make things easier to look over.

the DB schema?  If you want, I can pull that from my current source and
mail it to you.  But not tonight.


-- 
 .*********  Fight Back!  It may not be just YOUR life at risk.  *********.
 : phil stracchino : unix ronin : renaissance man : mystic zen biker geek :
 :  alaric at caerllewys.net|phil-stracchino at earthlink.net|phil at novylen.net  :
 :   2000 CBR929RR, 1991 VFR750F3 (foully murdered), 1986 VF500F (sold)   :
 :    Linux Now!   ...Because friends don't let friends use Microsoft.    :