Project

General

Profile

Bug #3754

Foreign key references not deleting on update

Added by Kyle Hazelwood almost 8 years ago. Updated almost 8 years ago.

Status:
Closed
Priority:
High
Category:
Database
Target version:
-
Start date:
04/23/2013
Due date:
% Done:

0%

Estimated time:
Duration:

Description

I assumed wrong that postgreSQL foreign key reference contraints would delete after the referenced row is updated. I thought ON UPDATE CASCADE would delete the rows like ON DELETE CASCADE does. I need to create a trigger or rule to do this or do it manually :(

History

#1 Updated by Kyle Hazelwood almost 8 years ago

  • Status changed from Assigned to Closed

Created triggers for both entries and comments tables that call functions deleting the referenced table rows.

Also available in: Atom PDF