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