Re: [Sqlalchemy-tickets] [sqlalchemy] #2765: Cascading with "delete-orphan" will insert new children, before deleting removed children, causing unique constraint violations

[sqlalchemy <mi...@zz...>]

#2765: Cascading with "delete-orphan" will insert new children, before deleting
removed children, causing unique constraint violations
-------------------------+-------------------------------------------------
      Reporter:          |      Owner:  zzzeek
  logandk                |     Status:  closed
          Type:  defect  |  Milestone:
      Priority:  medium  |   Severity:  no triage selected yet
     Component:  orm     |   Keywords:  orm,delete,orphan,unique,constraint
    Resolution:          |
  duplicate              |
Progress State:          |
  completed/closed       |
-------------------------+-------------------------------------------------
Changes (by zzzeek):

 * status:  new => closed
 * resolution:   => duplicate
 * status_field:  awaiting triage => completed/closed


Comment:

 this is #2501, there's no fix on the horizon.  You'll need to emit a
 flush() in between for the time being.

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2765#comment:1>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python