title: Why isn't sqlalchemy's default column value working
body: <p>I am using Postgresql 9.1 and SQLAlchemy 0.9.</p>
  
  <p>The problem is, '<strong><em>default=10</em></strong>' doesn't work.</p>
  
  <p>My Code:</p>
  
  <pre><code>conn_str = 'postgresql://test:pass@localhost/test'
  engine = create_engine(conn_str)
  metadata = MetaData(bind=engine)
  
  cols=[]
  cols += [Column('Name', VARCHAR(20), primary_key=True, nullable=False)]
  cols += [Column('age', INT, default=10, nullable=False )]
  Table('t1', metadata, *cols)
  metadata.create_all(engine)
  </code></pre>
  
  <p>psql:</p>
  
  <pre><code>test=&gt; \dS t1
              Table "public.t1"
  Column |         Type          | Modifiers
  --------+-----------------------+-----------
  Name   | character varying(20) | not null
  age    | integer               | not null
  Indexes:
      "t1_pkey" PRIMARY KEY, btree ("Name")
  </code></pre>
  
  <p>I tried with an SQL statement directly and it should look like:</p>
  
  <pre><code>test=&gt; \dS t2
                Table "public.t2"
   Column |         Type          | Modifiers
  --------+-----------------------+------------
   Name   | character varying(10) | not null
   age    | integer               | default 10
  Indexes:
      "t2_pkey" PRIMARY KEY, btree ("Name")
  </code></pre>
  
  <p>What am I doing wrong?</p>