title: How can I resolve this constraint error when trying to load only data via pgloader?
body: <p>I have the following .load file </p>
  
  <pre><code>LOAD DATABASE
       FROM      mysql://user:password@remotelocation/mydbname
       INTO postgresql://user@localhost/dbname
  
   WITH data only,truncate, workers = 8, concurrency = 1
  
    SET maintenance_work_mem to '128MB',
        work_mem to '12MB',
        search_path to 'mydbname'
  
   CAST type datetime to timestamptz drop default drop not null using zero-dates-to-null,
        type mediumint with extra auto_increment to bigserial,
        type date drop not null drop default using zero-dates-to-null,
        type tinyint to boolean using tinyint-to-boolean;
  </code></pre>
  
  <p>I get the error </p>
  
  <pre><code>Database error 2BP01: cannot drop constraint random_pkey on table random because other objects depend on it. 
  </code></pre>
  
  <p>Can I load the data without dropping the key? I also have tried adding the <code>disable triggers</code> parameter to the with clause and that didn't work as well. </p>
  
  <p>I am using postgre 9.6 and pgloader's version number is 3.3.2</p>