Re: Relation does not exist problem - Mailing list pgsql-novice

From Robert Wimmer
Subject Re: Relation does not exist problem
Date
Msg-id BAY139-F384D8DE3013C3F18D7968DD0B80@phx.gbl
Whole thread Raw
In response to Re: Relation does not exist problem  ("Oeschey, Lars (I/EK-142, extern)" <extern.Lars.Oeschey@AUDI.DE>)
Responses Re: Relation does not exist problem  ("Oeschey, Lars (I/EK-142, extern)" <extern.Lars.Oeschey@AUDI.DE>)
List pgsql-novice


>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


pgsql-novice by date:

Previous
From: "Oeschey, Lars (I/EK-142, extern)"
Date:
Subject: Re: Relation does not exist problem
Next
From: "Oeschey, Lars (I/EK-142, extern)"
Date:
Subject: Re: Relation does not exist problem