title: PostgreSQL search_path change not working as advertised
body: <p>I am using PostgreSQL 9.0.3 on RedHat.  The database contains two schemas, <code>public</code> and <code>wh</code>. I created a new role called <code>django</code>. I want this user to use the <code>wh</code> schema as it's default.</p>
  
  <p>Following the manual, I did:</p>
  
  <pre><code>ALTER USER django SET SEARCH_PATH TO wh, public;
  </code></pre>
  
  <p>This appears to work:</p>
  
  <pre><code>SHOW SEARCH_PATH;
  search_path 
  -------------
  wh, public
  </code></pre>
  
  <p>However, if I then do a <code>\dt</code>, only tables from the public schema are displayed. In the manual, changing the search path should have an immediate effect, and I should be able to access <code>wh</code> tables without a prefix, but this is not the case. Logging in and out preserves the changes to <code>search_path</code> but does not show any change of behavior.</p>
  
  <p>What am I missing?</p>