Index: openacs-4/packages/dotlrn/sql/postgresql/class-membership-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/class-membership-drop.sql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/dotlrn/sql/postgresql/class-membership-drop.sql 8 Aug 2006 21:26:22 -0000 1.3 +++ openacs-4/packages/dotlrn/sql/postgresql/class-membership-drop.sql 1 Nov 2013 21:08:29 -0000 1.4 @@ -24,38 +24,38 @@ -- @version $Id$ -- -create function inline_0() -returns integer as ' -begin +CREATE OR REPLACE FUNCTION inline_0() RETURNS integer AS $$ +BEGIN perform acs_rel_type__drop_type ( - ''dotlrn_student_rel'', - ''t'' + 'dotlrn_student_rel', + 't' ); perform acs_rel_type__drop_type ( - ''dotlrn_ta_rel'', - ''t'' + 'dotlrn_ta_rel', + 't' ); perform acs_rel_type__drop_type ( - ''dotlrn_ca_rel'', - ''t'' + 'dotlrn_ca_rel', + 't' ); perform acs_rel_type__drop_type ( - ''dotlrn_cadmin_rel'', - ''t'' + 'dotlrn_cadmin_rel', + 't' ); perform acs_rel_type__drop_type ( - ''dotlrn_instructor_rel'', - ''t'' + 'dotlrn_instructor_rel', + 't' ); return 0; -end;' language 'plpgsql'; +END; +$$ LANGUAGE plpgsql; select inline_0(); drop function inline_0();