title: Unable to use crosstab in Postgres
body: <p>Postgres 9.2.1 on OSX 10.9.2.</p>
  
  <p>If I run the following crosstab example query:</p>
  
  <pre><code>CREATE EXTENSION tablefunc; 
  
  CREATE TABLE ct(id SERIAL, rowid TEXT, attribute TEXT, value TEXT);
  INSERT INTO ct(rowid, attribute, value) VALUES('test1','att1','val1');
  
  SELECT *
  FROM crosstab(
    'select rowid, attribute, value
     from ct
     where attribute = ''att2'' or attribute = ''att3''
     order by 1,2')
  AS ct(row_name text, category_1 text, category_2 text, category_3 text);
  </code></pre>
  
  <p>I get: <code>ERROR:  extension "tablefunc" already exists</code></p>
  
  <p>But if I comment out <code>CREATE EXTENSION</code></p>
  
  <p>I get: <code>ERROR:  function crosstab(unknown) does not exist</code></p>
  
  <p>How can I get out of this vicious circle?  Is it a known issue?</p>