Re: ERROR: function crosstab(unknown, unknown) does not exist - Mailing list pgsql-general

Adrian Klaver <adrian.klaver@gmail.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
launchit 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