Re: DBIx::Recordset - detecting table linkages

[Gerald Richter <ri...@ecos.de>]

>
> So, why is it preferable to have different names for foreign and
> primary
> keys if the most succinct SQL can be generated from them having the
> same
> name?

Because if you have a lot of tables in yur db, DBIx::Recordset doesn't knows
which tables to join, if a lot of tables contains the same field name. At
least this is the reason why I choose this aproach. It could be an option to
dectect fields with the same name, but please make it an option, so it
doesn't break anything existing

Gerald

--------------------------------------------------------------
Gerald Richter     ecos electronic communication services gmbh
IT-Securitylösungen * dynamische Webapplikationen * Consulting

Post:       Tulpenstrasse 5          D-55276 Dienheim b. Mainz
E-Mail:     richter@ecos.de          Voice:   +49 6133 939-122
WWW:        http://www.ecos.de/      Fax:     +49 6133 939-333
--------------------------------------------------------------
|
|   ECOS BB-5000 Firewall- und IT-Security Appliance: www.bb-5000.info
|
+-------------------------------------------------------------


---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org