From: David Johnston <polobo@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Re: question on the information_schema
Date: Fri, 23 Aug 2013 08:53:30 -0700 (PDT)
Message-ID: <1377273210788-5768403.post@n5.nabble.com> (raw)
In-Reply-To: <52178080.7010908@gmail.com>
References: <52177664.5030908@gmail.com>
<1377270150147-5768391.post@n5.nabble.com>
<52177BC0.1060007@gmail.com>
<CAGrpgQ-uUWWxBc7iG1A7LVnomJ5artisotZFcaFtRHdhXCneug@mail.gmail.com>
<52178080.7010908@gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Salvatore Barone wrote
> This is the output of \d from psql. I logged in as "ssaa"
>
> Lista delle relazioni
> Schema | Nome | Tipo | Proprietario |
> Dimensione | Descrizione
> --------+----------------------------+---------+--------------+------------+-------------
> public | acquisti_persona_fisica | tabella | platinet | 8192
> bytes |
> public | acquisti_persona_giuridica | tabella | platinet | 0
> bytes |
> public | articolo | tabella | platinet | 8192
> bytes |
> public | fornitore | tabella | platinet | 0
> bytes |
> public | giacenza | tabella | platinet | 0
> bytes |
> public | persona_fisica | tabella | platinet | 8192
> bytes |
> public | persona_giuridica | tabella | platinet | 8192
> bytes |
> (7 righe)
>
> And this is the output of show search_path;
>
> search_path
> ----------------
> "$user",public
> (1 riga)
One thing to try is after you run your query as the postgres user issue a
"SET ROLE ssaa;" command to immediately pretend you are the ssaa user and
then execute the query again.
Also, as "ssaa" (both via SET ROLE and as a separate login), try issuing a
simple "SELECT * FROM table" for whatever table(s) you expect to see results
for.
One common problem that occurs in situations like this is that user
"postgres" and user "ssaa" are not connecting to the same database. The SET
ROLE will help diagnose that problem though there are other ways as well.
Likely the issue is either a "mis-connect" as mentioned above or it has to
do with table permissions; the information_schema query is not likely to be
broken. The problem, for me in particular, is that I do not know what
questions to ask to get you to adequately show the current permissions in
your setup. Assuming it is not the first problem then you, with the help of
others probably, will need to be much more verbose in showing what specific
setups are in place (GRANTs, REVOKEs, GROUP/ROLE, etc...) for the database
in question.
It is a worthwhile exercise to use a newly created test database and a newly
created user to try and get a minimal example working (even/especially if
incorrectly) and then supply the entirety of that example so we can review
exactly what you are doing. If you can get the example to work then the
system is functioning and it is only your specific configuration that is
broken - which again means we need much more specific information.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/question-on-the-information-schema-tp5768389p5768403.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: polobo@yahoo.com
Subject: Re: question on the information_schema
In-Reply-To: <1377273210788-5768403.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox