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

From Alban Hertroys
Subject Re: ERROR: function crosstab(unknown, unknown) does not exist
Date
Msg-id CAF-3MvP7ewSkpJ1ptB2fkbxXmOdkkVnduXPkBYTic2k7yU0yEQ@mail.gmail.com
Whole thread Raw
In response to Re: ERROR: function crosstab(unknown, unknown) does not exist  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
> 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+

One other thing you might want to verify: Does user XXX have the
PUBLIC schema in their search_path? It is by default, but some people
take it out for security reasons.

--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: ERROR: function crosstab(unknown, unknown) does not exist
Next
From: Andy Chambers
Date:
Subject: Cancel a pg_ctl stop