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

Reply via email to