Index: openacs-4/packages/bulk-mail/sql/postgresql/bulk-mail-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bulk-mail/sql/postgresql/bulk-mail-drop.sql,v diff -u -N -r1.2 -r1.3 --- openacs-4/packages/bulk-mail/sql/postgresql/bulk-mail-drop.sql 12 Jun 2002 13:53:13 -0000 1.2 +++ openacs-4/packages/bulk-mail/sql/postgresql/bulk-mail-drop.sql 27 Oct 2014 16:41:06 -0000 1.3 @@ -5,21 +5,22 @@ -- @version $Id$ -- -create function inline_0 () -returns integer as' -declare +CREATE FUNCTION inline_0 () +RETURNS integer AS $$ +DECLARE row RECORD; -begin +BEGIN for row in select bulk_mail_id from bulk_mail_messages loop perform bulk_mail__delete(row.bulk_mail_id); end loop; - perform acs_object_type__drop_type(''bulk_mail_message'', ''f''); + perform acs_object_type__drop_type('bulk_mail_message', 'f'); return null; -end;' language 'plpgsql'; +END; +$$ LANGUAGE plpgsql; select inline_0();