but, but.... it is even with the psql command...
it will differ if I put a -U parameter with postgres or 20020003
postgres, michiel or most other names will connect fine, however the user
20020003 will not...
I get that FATAL error... all users should be able to connect to the
database, according to pg_hba.conf
and when I do: SELECT * FROM pg_user; I get all users, including 20020003
returned... and 20030003 has userid 106, which is mentioned in the list
SELECT * FROM pg_group; so, the account should be set up correctly. A ALTER
USER 20020003 WITH ... has not helped either, but I am very certain the
user exists... but is not allowed to connect to the database...
But I will try to see what happens with query logging... never thought that
connecting would issue a query as well... not so strange an idea though...
I'll check it out...
Michiel
At 09:10 27-1-2003 -0500, Tom Lane wrote:
>Michiel Lange <michiel@minas.demon.nl> writes:
> > it is pretty strange... might it be a bug?
>
>I'm quite sure it's a bug in your code. Try turning on query logging so
>you can see what queries are being issued; maybe that will help solve
>the problem.
>
> regards, tom lane