Re: How can I use crosstab functons in PostgreSQL 9.3?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How can I use crosstab functons in PostgreSQL 9.3?
Дата
Msg-id 875.1444918753@sss.pgh.pa.us
обсуждение исходный текст
Ответ на How can I use crosstab functons in PostgreSQL 9.3?  (Rob Richardson <RDRichardson@rad-con.com>)
Ответы Re: How can I use crosstab functons in PostgreSQL 9.3?  (Tim Clarke <tim.clarke@manifest.co.uk>)
Re: How can I use crosstab functons in PostgreSQL 9.3?  (Rob Richardson <RDRichardson@rad-con.com>)
Re: How can I use crosstab functons in PostgreSQL 9.3?  (Rob Richardson <RDRichardson@rad-con.com>)
Список pgsql-general
Rob Richardson <RDRichardson@rad-con.com> writes:
> I am trying to learn about crosstab functions in ProgreSQL 9.3, but none of the examples I’ve found are working.  I
geterrors claiming the functions are unknown, but when I try running CREATE EXTENSION tablefunc, I am told that its
methodsalready exist. 

This looks like a search_path problem.  You could try "\dx+ tablefunc"
to see which schema its functions are in, then adjust your search_path
to include that, or else schema-qualify the function names.

            regards, tom lane


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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: pgpool ssl handshake failure
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Installing plpython3u