[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Gforge-devel] address@hidden: patch]
From: |
Ryan T. Sammartino |
Subject: |
[Gforge-devel] address@hidden: patch] |
Date: |
Wed, 22 Jan 2003 16:25:41 -0800 |
User-agent: |
Mutt/1.4i |
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