Ingeborg Hellemo Ingeborg.Hellemo@cc.uit.no writes:
https://<nav-host>/browse/service/ looks like this:
All services
dns (3)
ftp (1)
http (15)
https (4)
...
If i click one of the services with a count larger than 1 i get
[...]
ProgrammingError: ERROR: IN types character varying and integer cannot be
matched
[...]
Please fix.
This appears to related to the same problem reported in this bug:
http://sourceforge.net/tracker/index.php?func=detail&aid=1792351&gro...
I.e. stricter type checking in PostgreSQL 8.2. I don't know whether
there might be an option in postgresql.conf which allows you to reduce
the strictness as a workaround, though.
I've posted the bug here:
http://sourceforge.net/tracker/index.php?func=detail&aid=1822760&gro...
--
mvh
Morten Brekkevold
UNINETT
>From morten.brekkevold at uninett.no Tue Oct 30 14:42:23 2007
From: morten.brekkevold at uninett.no (Morten Brekkevold)
Date: Tue Oct 30 14:42:28 2007
Subject: [Nav-users] Home > IP Device Center > Services - "We're terribly
sorry"
In-Reply-To:
yyl7il4vj1x.fsf@voldsminde.uninett.no (Morten Brekkevold's
message of "Tue, 30 Oct 2007 14:16:58 +0100")
References:
200710291222.l9TCM0oV047496@barnetv.cc.uit.no
yyl7il4vj1x.fsf@voldsminde.uninett.no
Message-ID:
yyl1wbcvhvk.fsf@voldsminde.uninett.no
Morten Brekkevold
morten.brekkevold@uninett.no writes:
> I.e. stricter type checking in PostgreSQL 8.2. I don't know whether
> there might be an option in postgresql.conf which allows you to reduce
> the strictness as a workaround, though.
>
> I've posted the bug here:
>
http://sourceforge.net/tracker/index.php?func=detail&aid=1822760&gro...
Ingeborg, if you can, please try the attached patch for this problem
(I have no Postgres 8.2 to test on).
--
mvh
Morten Brekkevold
UNINETT