Doctrine 2 - ORM

Look into deferring foreign key checks until flush finished

Details

  • Type: Improvement Improvement
  • Status: Resolved Resolved
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: None
  • Fix Version/s: 2.3
  • Component/s: ORM
  • Security Level: All
  • Labels:
    None

Description

There are several timing issues that will be complicated to fix which relate to foreign key checks.

If we could optionally allow people to defer the foreign key checks until flush has fully completed we could simply solve them all, maybe even across all vendors?

Issue Links

is required for

Bug - A problem which impairs or prevents the functions of the product. DDC-959 Problem deleting when the foreign key is the primary key of the table

  • Major - Major loss of function.
  • Resolved - A resolution has been taken, and it is awaiting verification by reporter. From here issues are either reopened, or are closed.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Benjamin Eberlei added a comment -

Postgresql: http://stackoverflow.com/questions/139884/how-do-i-disable-referential-integrity-in-postgres-8-2
Mysql: http://cristian-radulescu.ro/article/disable-foreign-key-checks-in-mysql.html
Oracle: http://infolab.stanford.edu/~ullman/fcdb/oracle/or-triggers.html#deferring%20constraint%20checking
Mssql: No clue?!
Sqlite: no foreign key support (yet)
DB2: not researched (IBM should provide better DB2 support for PHP first).

Show
Benjamin Eberlei added a comment - Postgresql: http://stackoverflow.com/questions/139884/how-do-i-disable-referential-integrity-in-postgres-8-2 Mysql: http://cristian-radulescu.ro/article/disable-foreign-key-checks-in-mysql.html Oracle: http://infolab.stanford.edu/~ullman/fcdb/oracle/or-triggers.html#deferring%20constraint%20checking Mssql: No clue?! Sqlite: no foreign key support (yet) DB2: not researched (IBM should provide better DB2 support for PHP first).
Hide
Permalink
Guilherme Blanco added a comment -

As per https://github.com/doctrine/doctrine2/commit/3e601c3a53226ce981fe82db164f297a8d605ae7 all tests related to this issue are closed.
Marking this ticket as fixed on 2.3.

Show
Guilherme Blanco added a comment - As per https://github.com/doctrine/doctrine2/commit/3e601c3a53226ce981fe82db164f297a8d605ae7 all tests related to this issue are closed. Marking this ticket as fixed on 2.3.

People

  • Assignee:
    Guilherme Blanco
    Reporter:
    Benjamin Eberlei
Vote (1)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved: