title: Keep sequence created from BIGSERIAL when deleting table
body: <p>I have a postgres table creating with the following SQL:</p>
  
  <pre><code>CREATE TABLE mytable (
      mytable_id BIGSERIAL NOT NULL,
      mytable_char VARCHAR(8) NOT NULL
  )
  </code></pre>
  
  <p>This creates the table as well as an implicit <code>mytable_mytable_id_seq</code> sequence.</p>
  
  <p>Now, after creating 1.000.000 records, I want to split this table into partitioned tables (using inheritance). Because I link refer to the main table from other tables, I want to keep using the IDs from the original table in the new child tables and keep using the sequence.</p>
  
  <p>However, if I do <code>DROP TABLE mytable</code> it also deletes the sequence. How can I keep the sequence when dropping the table?</p>