Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> 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