Login | Register
My pages Projects Community openCollabNet

Discussions > users > [propel] Duplicate primaryKey in column does not through error until insert-sql

propel
Discussion topic

Back to topic list

[propel] Duplicate primaryKey in column does not through error until insert-sql

Reply

Author matthewh
Full name Matthew Hershberger
Date 2004-04-12 13:16:02 PDT
Message Hello everyone,

I've noticed a trend in the propel where problems that will occur in
insert-sql are not shown as errors/warnings during the phing build
phase. Is this just missing error handling or is there some other
reason?

Thanks,

Matt

On Apr 12, 2004, at 15:42, Hans Lellelid wrote:

> Hi Matt & Denny,
>
> I applied the fix below to the foreignkey.tpl template. If you update
> from CVS this should be there.
>
> I ended up using Matt's code w/o modification:
>
>> <?php foreach ($table->getForeignKeys() as $fk) { ?>
>> INDEX (<?php echo $fk->getLocalCol​umnNames()?>),
>> FOREIGN KEY (<?php echo $fk->getLocalCol​umnNames()?>) REFERENCES
>> <?php echo $fk->getForeignTableName() ?> (<?php echo
>> $fk->getForeignColumnNames() ?>),
>> <?php } ?>
>
> since MySQL/InnoDB does not complain if you define an index more than
> once. That made it easier than needing to check to see whether index
> already existed -- and I wasn't completely sure what would happen if
> column was part of another multi-column index, etc. We'll keep it like
> this unless someone has trouble with it.
>
> Thanks,
> Hans
>
> --------------------​--------------------​--------------------​---------
> To unsubscribe, e-mail: users-unsubscribe@pr​opel.tigris.org
> For additional commands, e-mail: users-help at propel dot tigris dot org
>
>


--------------------​--------------------​--------------------​---------
To unsubscribe, e-mail: users-unsubscribe@pr​opel.tigris.org
For additional commands, e-mail: users-help at propel dot tigris dot org

« Previous message in topic | 14 of 15 | Next message in topic »

Messages

Show all messages in topic

[propel] Syntax error in the manual. matthewh Matthew Hershberger 2004-04-09 07:10:13 PDT
     Re: [propel] Syntax error in the manual. hlellelid Hans Lellelid 2004-04-09 07:20:30 PDT
         Re: [propel] Syntax error in the manual. matthewh Matthew Hershberger 2004-04-09 09:46:16 PDT
             Re: [propel] Syntax error in the manual. hlellelid Hans Lellelid 2004-04-09 12:05:36 PDT
                 [propel] Many-to-Many Relationship Problem matthewh Matthew Hershberger 2004-04-12 10:30:16 PDT
                     Re: [propel] Many-to-Many Relationship Problem hlellelid Hans Lellelid 2004-04-12 11:53:52 PDT
                         Re: [propel] Many-to-Many Relationship Problem matthewh Matthew Hershberger 2004-04-12 12:20:37 PDT
                             RE: [propel] Many-to-Many Relationship Problem "Denny H dot Shimkoski" <dhs at hamfish dot org> "Denny H dot Shimkoski" <dhs at hamfish dot org> 2004-04-12 12:15:32 PDT
                                 RE: [propel] Many-to-Many Relationship Problem hlellelid Hans Lellelid 2004-04-12 12:31:33 PDT
                             [propel] Many-to-Many Relationship Problem Fix matthewh Matthew Hershberger 2004-04-12 12:31:19 PDT
                                 Re: [propel] Many-to-Many Relationship Problem Fix hlellelid Hans Lellelid 2004-04-12 12:34:14 PDT
                                     RE: [propel] Many-to-Many Relationship Problem "Denny H dot Shimkoski" <dhs at hamfish dot org> "Denny H dot Shimkoski" <dhs at hamfish dot org> 2004-04-12 12:27:38 PDT
                                 [propel] Fix applied -- Re: [propel] Many-to-Many Relationship Problem Fix hlellelid Hans Lellelid 2004-04-12 12:42:38 PDT
                                     [propel] Duplicate primaryKey in column does not through error until insert-sql matthewh Matthew Hershberger 2004-04-12 13:16:02 PDT
                                         Re: [propel] Duplicate primaryKey in column does not through error until insert-sql hlellelid Hans Lellelid 2004-04-12 13:25:27 PDT
Messages per page: