Index: openacs-4/packages/general-comments/sql/postgresql/general-comments-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/general-comments/sql/postgresql/general-comments-drop.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/general-comments/sql/postgresql/general-comments-drop.sql 28 May 2001 20:44:03 -0000 1.2 +++ openacs-4/packages/general-comments/sql/postgresql/general-comments-drop.sql 14 Jun 2001 19:52:22 -0000 1.3 @@ -2,6 +2,7 @@ -- packages/general-comments/sql/general-comments-drop.sql -- -- @author Phong Nguyen phong@arsdigita.com +-- @author Pascal Scheffers (pascal@scheffers.net) -- @creation-date 2000-10-12 -- -- @cvs-id $Id$ @@ -33,10 +34,13 @@ -- referential integrity violations when deleting a content -- item that has an image attachment. This is a temporary fix -- until ACS 4.1 is released. + + /* delete from images where image_id in (select latest_revision from cr_items - where parent_id = comment_rec.comment_id); + where parent_id = comment_rec.comment_id); + */ perform acs_message__delete(comment_rec.comment_id);