#71 MySQL Referential Integrity Support

2.0x
open
Randal Rioux
Database (11)
5
2008-07-02
2008-07-02
Micah Gersten
No

I saw a disturbing thing in the config file today:

* Note: Only PostgreSQL and MS-SQL Server databases support
* referential integrity. Use the associated
* create_acid_tbls_?_extra.sql script to add this
* functionality to the database.
*
* Referential integrity will greatly improve the
* speed of record deletion, but also slow record
* insertion.

MySQL in the InnoDB engine supports this as well.

http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html

Discussion

  • Randal Rioux
    Randal Rioux
    2008-07-02

    • milestone: --> 2.0x
    • assigned_to: nobody --> rrioux
     
  • Randal Rioux
    Randal Rioux
    2008-07-02

    Logged In: YES
    user_id=214749
    Originator: NO

    Thank you for submitting your feature request. Since we constantly make
    changes and consistantly improve the software, please upgrade to the latest
    version. If you ARE running the latest version and you have a good idea for a
    feature, thank you for submitting it.

    Thank you,

    BASE Development Team