Index: openacs-4/packages/tsearch2-driver/sql/postgresql/upgrade/upgrade-0.4d1-0.4d2.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/tsearch2-driver/sql/postgresql/upgrade/upgrade-0.4d1-0.4d2.sql,v diff -u -N --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/tsearch2-driver/sql/postgresql/upgrade/upgrade-0.4d1-0.4d2.sql 18 Dec 2004 22:06:41 -0000 1.1.2.1 @@ -0,0 +1,11 @@ +-- +-- +-- +-- @author Dave Bauer (dave@thedesignexperience.org) +-- @creation-date 2004-12-18 +-- @arch-tag: 46a0ecc0-b123-44dd-9e91-4a565f742071 +-- @cvs-id $Id: upgrade-0.4d1-0.4d2.sql,v 1.1.2.1 2004/12/18 22:06:41 daveb Exp $ +-- + +alter table txt drop constraint txt_object_id_fk; +alter table txt add constraint txt_object_id_fk foreign key (object_id) references acs_objects (object_id) on delete cascade; \ No newline at end of file