# HG changeset patch
# User Daniel Poelzleithner <poelzi@poelzi.org>
# Date 1286495830 -7200
# Node ID ca13b2614d101692c6f44077145bdf6ff2fe2fdc
# Parent  0758a2e0262013e29e490eae712ce8e78ebb2304
better be safe :-)

diff -r 0758a2e02620 -r ca13b2614d10 core.sql
--- a/core.sql	Thu Oct 07 19:45:12 2010 +0200
+++ b/core.sql	Fri Oct 08 01:57:10 2010 +0200
@@ -625,7 +625,7 @@
 
 CREATE FUNCTION update_supporter_drafts()
   RETURNS trigger
-  LANGUAGE 'plpgsql' AS $$
+  LANGUAGE 'plpgsql' VOLATILE AS $$
   BEGIN
     UPDATE supporter SET draft_id = NEW.id 
     WHERE initiative_id = NEW.initiative_id AND
diff -r 0758a2e02620 -r ca13b2614d10 update/core-update.v1.2.8-v1.2.9.sql
--- a/update/core-update.v1.2.8-v1.2.9.sql	Thu Oct 07 19:45:12 2010 +0200
+++ b/update/core-update.v1.2.8-v1.2.9.sql	Fri Oct 08 01:57:10 2010 +0200
@@ -7,7 +7,7 @@
 
 ALTER TABLE "supporter" ADD "auto_support" BOOLEAN NOT NULL DEFAULT 'f';
 
-CREATE FUNCTION update_supporter_drafts()
+CREATE FUNCTION VOLATILE update_supporter_drafts()
   RETURNS trigger
   LANGUAGE 'plpgsql' AS $$
   BEGIN