I should have mentioned (twice now) that I'm running under Windows 7. RobR
-----Original Message----- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Thursday, October 15, 2015 10:19 AM To: Rob Richardson Cc: pgsql-general General Subject: Re: [GENERAL] How can I use crosstab functons in PostgreSQL 9.3? Rob Richardson <rdrichard...@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 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 (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
