thanks John. Looks like I should just switch to Postgres These hidden rules
from MySQL are
just too annoying.
There aren't any such weird rules in the Pg land, I hope. Can someone with Pg
experience please
share his/her experiences with Rose DB?
thanks
- Praveen
----- Original Message ----
From: John Siracusa <[EMAIL PROTECTED]>
To: Rose::DB::Object list <rose-db-object@lists.sourceforge.net>
Sent: Monday, January 8, 2007 4:25:35 PM
Subject: Re: [RDBO] Can't detect Foreign Key via auto_initialize (MySQL 5.0.17)
On 1/8/07, Praveen Ray <[EMAIL PROTECTED]> wrote:
> Why didn't it detect Foreign Key definition as promised in the tutorial?
This message from an earlier thread provides the solution. Skip the
parts that aren't relevant and start reading at this line:
"You need to use the InnoDB storage engine in order to create "real" foreign
keys in MySQL, and even then there are very specific (and annoying) rules
surrounding the procedure. ..."
http://www.mail-archive.com/rose-db-object@lists.sourceforge.net/msg00929.html
The short answer is: use the InnoDB table type, create indexes on all
columns involved in the foreign key, and declare the foreign keys in
separate constraints rather than inline with each column definition.
-John
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
