Re: Relation does not exist problem

> >Though when I try to select something from a table
> >with user B, I get the error "Relation _table_ does not exist"
>
> the error mesage would be different, if user B has no rights
> for table
> _table_ . something like
> "permission denied for relation _table_".
>
> it looks like as if the table you asked for really does not
> exist. maybe you
> spelled it the wrong way.

not really... when I connect to the database with User A, I can see
everything perfectly (and select etc.) I have both connections parallel
in pgadmin, and can compare that way. It even happens in pgadmin, that I
get the error when I click on a table (so spelling shouldn't be a
problem). I also did add a "ALTER ROLE User B SET search_path=schema 1,
schema 2;" to the problem user...

Lars