Index: openacs-4/packages/bulk-mail/sql/postgresql/bulk-mail-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bulk-mail/sql/postgresql/bulk-mail-create.sql,v diff -u -N -r1.4 -r1.4.8.1 --- openacs-4/packages/bulk-mail/sql/postgresql/bulk-mail-create.sql 8 Aug 2006 21:26:15 -0000 1.4 +++ openacs-4/packages/bulk-mail/sql/postgresql/bulk-mail-create.sql 18 Aug 2014 20:54:39 -0000 1.4.8.1 @@ -46,24 +46,24 @@ ); -- create a new object type -create function inline_0 () -returns integer as ' -begin +CREATE OR REPLACE FUNCTION inline_0 () RETURNS integer AS $$ +BEGIN perform acs_object_type__create_type( - ''bulk_mail_message'', - ''Bulk Mail Message'', - ''Bulk Mail Messages'', - ''acs_object'', - ''bulk_mail_messages'', - ''bulk_mail_id'', - ''bulk_mail'', - ''f'', + 'bulk_mail_message', + 'Bulk Mail Message', + 'Bulk Mail Messages', + 'acs_object', + 'bulk_mail_messages', + 'bulk_mail_id', + 'bulk_mail', + 'f', null, - ''acs_object__default_name'' + 'acs_object__default_name' ); return null; -end;' language 'plpgsql'; +END; +$$ LANGUAGE plpgsql; select inline_0();