[Gforge-devel] activity tab

[Reinhard Spisser]

Hi all,

on postgres 8.1 (ubuntu dapper) I got the following
error when running the 20060216.sql file:

ERROR:  UNION types integer and text cannot be matched

I discovered that the error was related to the dates
used in the view definition, after adding a ::text the
error disappeared and the view seems to be correct
(now the activity tab shows me the correct activities
on the project).

I'm no real sql expert (especially on postgres) so I
don't know if I did the right thing.

The first part of the view definition now is (look at
the a.open_date):

CREATE VIEW activity_vw AS
SELECT
agl.group_id, 'trackeropen'::text AS section,
agl.group_artifact_id AS ref_id,
a.artifact_id as subref_id, a.summary as description,
a.open_date::text AS activity_date, u.user_id,
u.user_name, u.realname
FROM artifact_group_list agl JOIN artifact a using
(group_artifact_id),
users u WHERE u.user_id=a.submitted_by
UNION
.........

Is this a correct way to solve the problem and it is
also supported on previous versions of postgres? If
yes, I can commit these changes.


Thanks in advance

Reinhard
BTW; I also need to add a "grant all on activity_vw to
gforge" to give the right permissions to the gforge
user.


Reinhard Spisser
reinhard at spisser.it

Chiacchiera con i tuoi amici in tempo reale! 
 http://it.yahoo.com/mail_it/foot/*http://it.messenger.yahoo.com