Re: [Gforge-devel] address@hidden: patch]

[Tom Copeland]

I'd rather see a new sql file if you have time... just to maintain
consistency....

Tom

----- Original Message -----
From: "Ryan T. Sammartino" <address@hidden>
To: <address@hidden>
Sent: Wednesday, January 22, 2003 7:25 PM
Subject: [Gforge-devel] address@hidden: patch]


>
> 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
>
>
> _______________________________________________
> Gforge-devel mailing list
> address@hidden
> http://mail.nongnu.org/mailman/listinfo/gforge-devel
>