Re: Relation does not exist problem

>From: "Oeschey, Lars (I/EK-142, extern)" <extern.Lars.Oeschey@AUDI.DE>
>To: <pgsql-novice@postgresql.org>
>Subject: Re: [NOVICE] Relation does not exist problem
>Date: Tue, 18 Sep 2007 10:38:23 +0200
>
> > > it looks like as if the table you asked for really does not
> > exist. maybe
> > > you spelled it the wrong way.
>
> > Right. Or the table are in a different schema.
>
>nope, I checked that with
>
>select tablename,schemaname from pg_tables where schemaname='etefas';
>
>when I do a select from a table I
>get a "no permission on schema" error. The "Relation does not exist"
>error comes up when I select a table in pgadmin. So it seems to come
>down to a permission problem, but where?
>
GRANT USAGE ON SCHEMA ... TO ...

regards Sepp

_________________________________________________________________
JETZT die neueste Version des Windows Live Messenger downloaden!
http://get.live.com/de-at/messenger/overview