Index: openacs-4/packages/dotlrn/sql/postgresql/user-extension-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/user-extension-drop.sql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/dotlrn/sql/postgresql/user-extension-drop.sql 8 Aug 2006 21:26:22 -0000 1.3 +++ openacs-4/packages/dotlrn/sql/postgresql/user-extension-drop.sql 1 Nov 2013 21:08:29 -0000 1.4 @@ -24,54 +24,54 @@ -- -- -create function inline_0() -returns integer as ' -begin +CREATE OR REPLACE FUNCTION inline_0() RETURNS integer AS $$ +BEGIN perform acs_sc_binding__delete ( - ''UserData'', - ''dotlrn_user_extension'' + 'UserData', + 'dotlrn_user_extension' ); perform acs_sc_impl_alias__delete ( - ''UserData'', - ''dotlrn_user_extension'', - ''UserNew'' + 'UserData', + 'dotlrn_user_extension', + 'UserNew' ); perform acs_sc_impl_alias__delete ( - ''UserData'', - ''dotlrn_user_extension'', - ''UserApprove'' + 'UserData', + 'dotlrn_user_extension', + 'UserApprove' ); perform acs_sc_impl_alias__delete ( - ''UserData'', - ''dotlrn_user_extension'', - ''UserDeapprove'' + 'UserData', + 'dotlrn_user_extension', + 'UserDeapprove' ); perform acs_sc_impl_alias__delete ( - ''UserData'', - ''dotlrn_user_extension'', - ''UserModify'' + 'UserData', + 'dotlrn_user_extension', + 'UserModify' ); perform acs_sc_impl_alias__delete ( - ''UserData'', - ''dotlrn_user_extension'', - ''UserDelete'' + 'UserData', + 'dotlrn_user_extension', + 'UserDelete' ); -- create the implementation perform acs_sc_impl__delete( - ''UserData'', - ''dotlrn_user_extension'' + 'UserData', + 'dotlrn_user_extension' ); return 0; -end;' language 'plpgsql'; +END; +$$ LANGUAGE plpgsql; select inline_0(); drop function inline_0();