Rob Richardson <[email protected]> writes:
> I am trying to learn about crosstab functions in ProgreSQL 9.3, but none of
> the examples Iâve found are working. I get errors claiming the functions
> are unknown, but when I try running CREATE EXTENSION tablefunc, I am told
> that its methods already 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
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general