liquid_feedback_core
changeset 80:ca13b2614d10
better be safe :-)
author | Daniel Poelzleithner <poelzi@poelzi.org> |
---|---|
date | Fri Oct 08 01:57:10 2010 +0200 (2010-10-08) |
parents | 0758a2e02620 |
children | dfa8e6a1f1e7 |
files | core.sql update/core-update.v1.2.8-v1.2.9.sql |
line diff
1.1 --- a/core.sql Thu Oct 07 19:45:12 2010 +0200 1.2 +++ b/core.sql Fri Oct 08 01:57:10 2010 +0200 1.3 @@ -625,7 +625,7 @@ 1.4 1.5 CREATE FUNCTION update_supporter_drafts() 1.6 RETURNS trigger 1.7 - LANGUAGE 'plpgsql' AS $$ 1.8 + LANGUAGE 'plpgsql' VOLATILE AS $$ 1.9 BEGIN 1.10 UPDATE supporter SET draft_id = NEW.id 1.11 WHERE initiative_id = NEW.initiative_id AND
2.1 --- a/update/core-update.v1.2.8-v1.2.9.sql Thu Oct 07 19:45:12 2010 +0200 2.2 +++ b/update/core-update.v1.2.8-v1.2.9.sql Fri Oct 08 01:57:10 2010 +0200 2.3 @@ -7,7 +7,7 @@ 2.4 2.5 ALTER TABLE "supporter" ADD "auto_support" BOOLEAN NOT NULL DEFAULT 'f'; 2.6 2.7 -CREATE FUNCTION update_supporter_drafts() 2.8 +CREATE FUNCTION VOLATILE update_supporter_drafts() 2.9 RETURNS trigger 2.10 LANGUAGE 'plpgsql' AS $$ 2.11 BEGIN