Index: openacs-4/packages/bookmarks/sql/postgresql/bookmarks-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bookmarks/sql/postgresql/bookmarks-create.sql,v diff -u -r1.27 -r1.28 --- openacs-4/packages/bookmarks/sql/postgresql/bookmarks-create.sql 26 Jan 2016 08:43:56 -0000 1.27 +++ openacs-4/packages/bookmarks/sql/postgresql/bookmarks-create.sql 27 Jan 2016 11:03:44 -0000 1.28 @@ -647,8 +647,8 @@ END; $$ LANGUAGE plpgsql; -CREATE FUNCTION bookmark__toggle_open_close_all (integer, boolean, integer) -RETURNS integer AS ' +CREATE OR REPLACE FUNCTION bookmark__toggle_open_close_all (bigint, boolean, integer) +RETURNS integer AS $$ DECLARE p_browsing_user_id ALIAS FOR $1; -- in bm_bookmarks.owner_id%TYPE, p_closed_p ALIAS FOR $2; -- in bm_in_closed_p.closed_p%TYPE default f, @@ -678,7 +678,7 @@ RETURN 0; END; -' LANGUAGE 'plpgsql'; +$$ LANGUAGE plpgsql; CREATE FUNCTION bookmark__new_root_folder (integer, integer)