Akash KC :
You have to add ON DELETE CASCADE constraint in following way:\n\nALTER TABLE table1 ADD CONSTRAINT \"tbl1_tbl2_fkey\" FOREIGN KEY(reference_key) REFERENCES table2 ON DELETE CASCADE;\n\n\nThen, you can simply execute the DELETE query\n\n DELETE FROM fs_item where itemid = 700001803\n",
2012-09-14T09:00:23