Re: ERROR: function crosstab(unknown, unknown) does not exist

From: Alban Hertroys <haramrae(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
Cc: Stefan Schwarzer <stefan(dot)schwarzer(at)unep(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: function crosstab(unknown, unknown) does not exist
Date: 2012-07-05 15:09:53
Message-ID: CAF-3MvP7ewSkpJ1ptB2fkbxXmOdkkVnduXPkBYTic2k7yU0yEQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2012-07-05 16:12:01 Re: Cancel a pg_ctl stop
Previous Message Adrian Klaver 2012-07-05 15:02:31 Re: ERROR: function crosstab(unknown, unknown) does not exist