title: Drop "Owned by" in Flyway
body: <p>Starting working on an existing Java web application project with Flyway, I am unable to deploy it due to an owner-related issue, &quot;sequence must have same owner as table it is linked to&quot;. The sql state is &quot;55000&quot; and the error code is 0.</p>
  <p>A DB script for Flyway</p>
  <pre><code>create sequene if not exists my_db.my_table_uid_seq
  start 1
  increment by 1000
  owned by my_db.my_table.uid
  </code></pre>
  <p>and the table to which the sequence is linked to has</p>
  <pre><code>create table if not exists my_db.my_table (...);
  alter table my_db.my_table owner to userx;
  </code></pre>
  <p>The problem can be resolved if I can drop the &quot;owned by ...&quot;.</p>
  <p>With Flyway, the task should be carried out by a script file with a content</p>
  <pre><code>drop owned by my_db.my_table.uid
  </code></pre>
  <p>Because those script files are running by sequence, the script file with the above content will run last. That means that the previous script will run and the error won't be resolved.</p>
  <p>How to resolve the problem then?</p>