Adrian Klaver <adrian.kla...@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 launch it 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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
