Er fikset. Manglet plpgsql.

- odd arne

-----Original Message----- From: owner-nav-users@itea.ntnu.no on behalf of Hauge Odd Arne Sent: Sun 30-May-04 19:03 To: Kristian Eide; nav-users@itea.ntnu.no Cc: Subject: ProgrammingError: ERROR: emotd: permission denied

Hallo.

Etter oppgradering til beta5 kommer jeg inn p? Nav via web (/index.py/index). F?r meldingen: ProgrammingError: ERROR: emotd: permission denied

select emotd.emotdid, title, description, last_changed, author, type, publish_start, publish_end, affected, downtime, count(value) as units from emotd left outer join emotd_related using (emotdid) where publish_end > now() and publish_start < now() group by emotd.emotdid, title, description, last_changed, author, type, publish_start, publish_end, affected, downtime order by last_changed desc, publish_end desc limit 20 offset 0

- odd arne

Odd Arne Hauge H?gskolen i Molde