8 Nov
2006
8 Nov
'06
15:42
Christian Goutrie wrote, On 07-11-2006 10:13:
ProgrammingError: ERROR: relation "accountingroup" does not exist
SELECT AccountInGroup.accountid, groupid FROM AccountInGroup WHERE (AccountInGroup.accountid='0')
I If I try sql by hand in the CLI, it works. I'm puzzled now. Any idea, how to get it working? Some case-sensitive related problems?
Exactly what did you do when you say you tried "sql by hand in the CLI"? Which arguments did you pass to psql, and which SQL statements did you run?
--
mvh
Morten Brekkevold
UNINETT
>From morten.brekkevold at uninett.no Wed Nov 8 14:47:03 2006
From: morten.brekkevold at uninett.no (Morten Brekkevold)
Date: Wed Nov 8 14:47:21 2006
Subject: [Nav-users] Announcement: NAV 3.1.1 is out
In-Reply-To: 4551DDEC.7010009@uninett.no
References: 4551DDEC.7010009@uninett.no
Message-ID: 4551DFD7.4080000@uninett.no
Morten Brekkevold wrote, On 08-11-2006 14:38:
> NAV 3.1.0 is now available for download at SourceForge
^^^^^
I did of course mean, as the subject says, NAV 3.1.1 :-)
--
mvh
Morten Brekkevold
UNINETT
>From goutrie at rapideye.de Wed Nov 8 15:28:21 2006
From: goutrie at rapideye.de (Christian Goutrie)
Date: Wed Nov 8 15:28:37 2006
Subject: [Nav-users] Database problem
In-Reply-To: 4551DEAB.9090200@uninett.no
References: 200611071013.30970.goutrie@rapideye.de
4551DEAB.9090200@uninett.no
Message-ID: 200611081528.21461.goutrie@rapideye.de
On Wednesday 08 November 2006 14:42, Morten Brekkevold wrote:
> Christian Goutrie wrote, On 07-11-2006 10:13:
> > ProgrammingError: ERROR: relation "accountingroup" does not exist
> >
> > SELECT
> > AccountInGroup.accountid, groupid
> > FROM
> > AccountInGroup
> > WHERE
> > (AccountInGroup.accountid='0')
> >
> > -------------------------------------------------------------------------
> >-----
> >
> > I If I try sql by hand in the CLI, it works. I'm puzzled now. Any idea,
> > how to get it working? Some case-sensitive related problems?
>
> Exactly what did you do when you say you tried "sql by hand in the CLI"?
> Which arguments did you pass to psql, and which SQL statements did you
> run?
Ok, maybe I forgot something, so here are some more details:
sql by hand means, that I passed the statement directly via the psql:
-------------------------------------
me@it005:~> psql -U nav -d manage
Password for user nav:
Welcome to psql 8.1.3, the PostgreSQL interactive terminal.
manage=# SELECT AccountInGroup.accountid, groupid FROM AccountInGroup WHERE
(AccountInGroup.accountid='0');
accountid | groupid
-----------+---------
(0 rows)
manage=#\q
me@it005:~>
-------------------------------------
I don't know, if this "0 rows"-result produces the relation error.
Is it right, or did I forgot to put some data into the database? I just
followed the INSTALL-instructions, and AFAIR there were no errors while
populating the tables.
Christian