title: How to generate uuid with PostgreSQL 8.4.4 on Ubuntu 10.04?
body: <p>I am running PostgreSQL 8.4.4 with Ubuntu 10.04.</p>
  
  <p>I am trying to generate uuid but can't find a way to do it.</p>
  
  <p>I do have the uuid-ossp.sql in <code>/usr/share/postgresql/8.4/contrib/uuid-ossp.sql</code></p>
  
  <p>When I try this is what I get : </p>
  
  <pre><code>postgres=# SELECT uuid_generate_v1();
  ERROR:  function uuid_generate_v1() does not exist
  LINE 1: SELECT uuid_generate_v1();
                 ^
  HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
  </code></pre>
  
  <p>Any idea ?</p>