[Gforge-devel] activity tab

[Tim Perdue]

Reinhard Spisser wrote:
> 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

You shouldn't have to if it was imported as the gforge user...

Those dates should be integers...

Tim