On 07/05/2012 07:46 AM, Stefan Schwarzer wrote:
Now, when I launch a query which includes "crosstab()" as a postgres user, everything works fine. However, if I launch it as user XXX, it complaints:
The search path is indicated as: "$user", public, metadata, admin, gis, tablefunc, postgis, topology I added a GRANT USAGE ON SCHEMA tablefunc TO XXX. Just in case, but this didn't solve the problem. Still wondering why it works for user Postgres, but not for user XXX...Using psql log in as user XXX and run SELECT current_schemas('f'); Do same as the postgres user. Let us know the results.Ahh…. Indeed, no "tablefunc" schema in there. So, what do I need to do? And what does the command mean?
See here for info: http://www.postgresql.org/docs/9.1/interactive/functions-info.html Per Toms suggestion you need to check the permissions on the schema. One way to do that is, from psql type the following and enter: \dn+
-- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
