title: postgresql drop table
body: <p>I have two tables (tbl and tbl_new) that both use the same sequence (tbl_id_seq).  I'd like to drop one of those tables.  On tbl, I've removed the modifier "not null default nextval('tbl_id_seq'::regclass)" but that modifier remains on tbl_new.  I'm getting the following error:</p>
  
  <p>ERROR:  cannot drop table tbl because other objects depend on it
  DETAIL:  default for table tbl_new column id depends on sequence tbl_id_seq</p>
  
  <p>After reviewing <a href="http://www.postgresql.org/docs/9.1/static/sql-droptable.html" rel="nofollow">http://www.postgresql.org/docs/9.1/static/sql-droptable.html</a>
  It looks like there is only CASCADE and RESTRICT as options.</p>