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

Поиск
Список
Период
Сортировка
От Stefan Schwarzer
Тема Re: ERROR: function crosstab(unknown, unknown) does not exist
Дата
Msg-id 136AF8EA-9975-45E9-87BD-588338A5084B@unep.org
обсуждение исходный текст
Ответ на Re: ERROR: function crosstab(unknown, unknown) does not exist  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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
ALLPRIVILEGES ON SCHEMA tablefunc TO xxx;"…. and now it works. Great! Merci & Danke! 

В списке pgsql-general по дате отправления:

Предыдущее
От: Darren Duncan
Дата:
Сообщение: Re: Finding Duplicate Rows during INSERTs
Следующее
От: Steven Schlansker
Дата:
Сообщение: Ignore hash indices on replicas