Index: openacs-4/packages/forums/sql/postgresql/forums-forums-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/postgresql/forums-forums-create.sql,v diff -u -r1.9 -r1.10 --- openacs-4/packages/forums/sql/postgresql/forums-forums-create.sql 12 Aug 2013 09:34:30 -0000 1.9 +++ openacs-4/packages/forums/sql/postgresql/forums-forums-create.sql 25 Aug 2013 10:04:21 -0000 1.10 @@ -78,9 +78,12 @@ from forums_forums where enabled_p = 't'; -create function inline_0 () -returns integer as' -begin + +-- procedure inline_0/0 +-- +CREATE OR REPLACE FUNCTION inline_0( +) RETURNS integer AS $$ +BEGIN perform acs_object_type__create_type( 'forums_forum', 'Forums Forum', Index: openacs-4/packages/forums/sql/postgresql/upgrade/upgrade-1.1.2d4-1.1.2d5.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/postgresql/upgrade/upgrade-1.1.2d4-1.1.2d5.sql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/forums/sql/postgresql/upgrade/upgrade-1.1.2d4-1.1.2d5.sql 12 Aug 2013 09:34:30 -0000 1.3 +++ openacs-4/packages/forums/sql/postgresql/upgrade/upgrade-1.1.2d4-1.1.2d5.sql 25 Aug 2013 10:04:21 -0000 1.4 @@ -25,9 +25,9 @@ delete from acs_permissions where privilege = 'forum_post'; -create function inline_0 () -returns integer as' -begin +CREATE OR REPLACE FUNCTION inline_0( +) RETURNS integer AS $$ +BEGIN perform acs_privilege__remove_child('read','forum_read'); perform acs_privilege__remove_child('create','forum_create'); perform acs_privilege__remove_child('write','forum_write');