gehel wrote:
[EMAIL PROTECTED] wrote: I'm using HSQLDB and see that the hibernate schema-export tool nicely creates the primary key over both foreign keys, so I expect that to happen on all databases that support it (end of quote) I'm using PostgreSQL and the PK is actually PK(A_FK, B_FK), there is no "artificial" PK generated. Good thing is that the uniqueness of (A_FK,B_FK) is checked. So be carefull, dont count too much on a super PK being generated ! (end of quote) yup, that's what I meant, the primary key is created over (= enveloping) both foreign keys .. no additional PK whatsoever (which is good for implied join tables) -- Wouter Zoons - [EMAIL PROTECTED] http://www.andromda.org/ _________________________________________________________ Reply to the post : http://galaxy.andromda.org/forum/viewtopic.php?p=1399#1399 Posting to http://forum.andromda.org/ is preferred over posting to the mailing list! ------------------------------------------------------- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click _______________________________________________ Andromda-user mailing list Andromda-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/andromda-user