On 07/04/2012 11:20 PM, 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:Are you schema qualifying the function name when you use it? If not, does user XXX have schema tablefunc in their search_path?Also, does user XXX have USAGE permission on the schema containing the extension? Usually, if you're going to stick an extension into a schema other than public, you're going to want to grant usage on that schema to PUBLIC, or at least more than nobody.Strange thing is that if I specify the schema for the crosstab function: SELECT * FROM tablefunc.crosstab( 'SEL…. than it works. 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. -- 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
[Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Programming PHP] [Kernel Newbies] [PHP Classes] [Find Someone Nice] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]