Index: openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.7.0d1-5.7.0d2.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.7.0d1-5.7.0d2.sql,v diff -u -N -r1.1 -r1.1.8.1 --- openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.7.0d1-5.7.0d2.sql 4 Oct 2010 21:59:20 -0000 1.1 +++ openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.7.0d1-5.7.0d2.sql 17 Aug 2019 09:36:18 -0000 1.1.8.1 @@ -3,10 +3,13 @@ -- --- The following function get's rid of the foreign key constraint between cr_folders(folder_id) and cr_items(item_id), --- at somepoint ( upgrade-5.4.2d1-5.42d2 ) it was added using the statement "alter table add foreign key .. " --- which will add a constraint with name $1, since this is not for sure ( could have also other name assigned), we better look for the right constraint name --- to be deleted using pg_constraint and pg_class table +-- The following function gets rid of the foreign key constraint +-- between cr_folders(folder_id) and cr_items(item_id), at some point +-- ( upgrade-5.4.2d1-5.42d2 ) it was added using the statement "alter +-- table add foreign key .. " which will add a constraint with name +-- $1, since this is not for sure ( could have also other name +-- assigned), we better look for the right constraint name to be +-- deleted using pg_constraint and pg_class table create function inline_0 () returns integer as '