Re: [sqlalchemy] DELETE CASCADE does not work when foreing key can be nulleable

2017-07-21 Thread Mauro Caceres
Yes, your test is working. In fact Im using pyramid-sqlachemy but the model is defined as show here. I will keep looking to see where is the issue Thanks and I will keep you posted On Friday, July 21, 2017 at 11:16:25 AM UTC-3, Mike Bayer wrote: > > On Fri, Jul 21, 2017 at 7:57 AM, Mauro C

[sqlalchemy] DELETE CASCADE does not work when foreing key can be nulleable

2017-07-21 Thread Mauro Caceres
Hi Guys, Im using sqlachemy SQLAlchemy==1.0.14 on PostgresDB. Im trying to understand if it is possible to delete all childs in a one to many relation but with the distinction that there would be orphans in the table, that is childs with the foreign key in NULL. This is what I have Class