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