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

From: Stefan Schwarzer <stefan(dot)schwarzer(at)unep(dot)org>
To: pgsql-general(at)postgresql(dot)org
Cc: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: ERROR: function crosstab(unknown, unknown) does not exist
Date: 2012-07-10 05:31:53
Message-ID: 136AF8EA-9975-45E9-87BD-588338A5084B@unep.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> If the textual value of search_path (as per "show search_path") lists
> the schema but current_schemas() doesn't, I have to think that you've
> got a permissions problem --- the system will silently ignore any
> search_path entries for which you don't have USAGE permission.
> You said you'd done a GRANT but I think you must've fat-fingered it
> somehow …

Thanks so much Tom, Adrian & Alban. After various tries, I finally dropped again the schema, recreated it, and "GRANT ALL PRIVILEGES ON SCHEMA tablefunc TO xxx;"…. and now it works. Great! Merci & Danke!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steven Schlansker 2012-07-10 07:09:48 Ignore hash indices on replicas
Previous Message Darren Duncan 2012-07-10 02:54:23 Re: Finding Duplicate Rows during INSERTs