Postgres Pro
Downloads
Home   >   mailing lists

Re: How can I use crosstab functons in PostgreSQL 9.3? - Mailing list pgsql-general

From Rob Richardson
Subject Re: How can I use crosstab functons in PostgreSQL 9.3?
Date
Msg-id 67D108EDFAD3C148A593E6ED7DCB4BBD014F1A1537@RADCONWIN2K8PDC.radcon.local
Whole thread Raw
In response to Re: How can I use crosstab functons in PostgreSQL 9.3?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
I should have mentioned (twice now) that I'm running under Windows 7.

RobR

-----Original Message-----
From: Tom Lane [mailto:tgl@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 <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
functionnames.
 

            regards, tom lane

pgsql-general by date:

Previous
From: Rob Richardson
Date:
Subject: Re: How can I use crosstab functons in PostgreSQL 9.3?
Next
From: Igor Stassiy
Date:
Subject: Cast hstore type to bytea (and later to hex possibly)