Adrian Klaver <adrian.klaver@xxxxxxxxx> writes: > On 07/03/2012 06:48 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: > 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. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
