[Gforge-devel] address@hidden: patch]

[Ryan T. Sammartino]

My install at work uses pgsql 7.1.3 and it had some problems with my
20030109.sql... specifically, posting a news item resulted in a "More
than one column returned" db error.  Has anyone else run into that?
The patch belows fixes the problem, although I haven't tried it on 7.3
yet (I imagine it will work).  Should I committ this patch or create a
new 200301xx.sql file to fix the problem?



----- Forwarded message from "Sammartino, Ryan" <address@hidden> -----

From: "Sammartino, Ryan" <address@hidden>
Subject: patch
Date: Wed, 22 Jan 2003 08:55:18 -0800
Message-id: <address@hidden>
To: address@hidden

Index: 20030109.sql
===================================================================
RCS file: /cvsroot/gforge/gforge/db/20030109.sql,v
retrieving revision 1.2
diff -u -r1.2 20030109.sql
--- 20030109.sql        11 Jan 2003 01:44:03 -0000      1.2
+++ 20030109.sql        22 Jan 2003 16:55:04 -0000
@@ -2,6 +2,11 @@
 ---
 --- This function updates the project_sums_agg count for a given type.
 ---
+DROP TRIGGER surveys_agg_trig ON surveys;
+DROP TRIGGER mail_agg_trig ON mail_group_list;
+DROP TRIGGER fmsg_agg_trig ON forum;
+DROP TRIGGER fora_agg_trig ON forum_group_list;
+DROP FUNCTION project_sums();
 CREATE FUNCTION "project_sums" () RETURNS OPAQUE AS '
        DECLARE
                num integer;
@@ -64,7 +69,7 @@
                ---
                --- See if this group already has a row in project_sums_agg for 
these things
                ---
-               PERFORM * FROM project_sums_agg WHERE curr_group=group_id AND 
type=TG_ARGV[0];
+               PERFORM count FROM project_sums_agg WHERE curr_group=group_id 
AND type=TG_ARGV[0];
 
                IF NOT FOUND THEN
                        ---


----- End forwarded message -----

-- 
Ryan T. Sammartino
http://members.shaw.ca/ryants/
He who makes a beast of himself gets rid of the pain of being a man.
                -- Dr. Johnson