Adrian Klaver <[email protected]> wrote:
>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
>[email protected]
>
>
>
>--
>Sent via pgsql-general mailing list ([email protected])
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-general
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
