From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | Stefan Schwarzer <stefan(dot)schwarzer(at)unep(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ERROR: function crosstab(unknown, unknown) does not exist |
Date: | 2012-07-05 15:02:31 |
Message-ID: | 4FF5AC87.9070003@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 07/05/2012 07:46 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:
>>>
>>> The search path is indicated as:
>>>
>>> "$user", public, metadata, admin, gis, tablefunc, postgis, topology
>>>
>>> I added a GRANT USAGE ON SCHEMA tablefunc TO XXX. Just in case, but this didn't solve the problem. Still wondering why it works for user Postgres, but not for user XXX...
>>>
>>
>> Using psql log in as user XXX and run SELECT current_schemas('f');
>> Do same as the postgres user.
>> Let us know the results.
>
> Ahh…. Indeed, no "tablefunc" schema in there. So, what do I need to do? And what does the command mean?
See here for info:
http://www.postgresql.org/docs/9.1/interactive/functions-info.html
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+
>
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Alban Hertroys | 2012-07-05 15:09:53 | Re: ERROR: function crosstab(unknown, unknown) does not exist |
Previous Message | Tom Lane | 2012-07-05 14:51:29 | Re: ERROR: function crosstab(unknown, unknown) does not exist |