Re: Database problem

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 <at> 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 <at> 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