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?
Re: How can I use crosstab functons in PostgreSQL 9.3? Re: How can I use crosstab functons in PostgreSQL 9.3? |
| Список | 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 по дате отправления: