1 files changed, 8 insertions, 0 deletions
diff --git a/lib/sql/message.sql b/lib/sql/message.sql
new file mode 100644
index 000000000..94d7a3496
--- /dev/null
+++ b/lib/sql/message.sql
@@ -0,0 +1,8 @@
+CREATE OR REPLACE FUNCTION message( content text) RETURNS void AS
+$BODY$
+  BEGIN
+    INSERT INTO xxx VALUES (nextval('xxx_id_seq'), 'message from stored procedure: ' || content, current_timestamp);
+    RAISE EXCEPTION 'Oh no';
+    RETURN;
+  END;
+$BODY$ LANGUAGE plpgsql VOLATILE COST 100;