<p>That is to say that running </p>

<div class="highlight"><pre>sqlt -f DBI --dsn <span class="s1">'dbi:Pg:host=&lt;hostname&gt;;dbname=&lt;dbname&gt;'</span> --db-user <span class="s1">'&lt;db-user&gt;'</span> -t MySQL
</pre></div>

<p>results in </p>

<div class="highlight"><pre><span class="k">CREATE</span> <span class="k">TABLE</span> <span class="o">`</span><span class="n">migrate_version</span><span class="o">`</span> <span class="p">(</span>
  <span class="o">`</span><span class="n">repository_id</span><span class="o">`</span> <span class="nb">text</span> <span class="k">NOT</span> <span class="k">NULL</span><span class="p">,</span>
  <span class="o">`</span><span class="n">repository_path</span><span class="o">`</span> <span class="nb">text</span> <span class="k">NULL</span><span class="p">,</span>
  <span class="o">`</span><span class="k">version</span><span class="o">`</span> <span class="nb">integer</span> <span class="k">NULL</span><span class="p">,</span>
  <span class="k">UNIQUE</span> <span class="k">INDEX</span> <span class="o">`</span><span class="n">migrate_version_pkey</span><span class="o">`</span> <span class="p">(</span><span class="o">`</span><span class="nb">ARRAY</span><span class="p">(</span><span class="mi">0</span><span class="n">xa923264</span><span class="p">)</span><span class="o">`</span><span class="p">)</span>
<span class="p">);</span>
</pre></div>

<p>Other parsers effected is unknown and only the PostgreSQL DBI parser was investigated</p>

<p>This patch fixes this ensuring the result is</p>

<div class="highlight"><pre><span class="k">CREATE</span> <span class="k">TABLE</span> <span class="o">`</span><span class="n">migrate_version</span><span class="o">`</span> <span class="p">(</span>
  <span class="o">`</span><span class="n">repository_id</span><span class="o">`</span> <span class="nb">text</span> <span class="k">NOT</span> <span class="k">NULL</span><span class="p">,</span>
  <span class="o">`</span><span class="n">repository_path</span><span class="o">`</span> <span class="nb">text</span> <span class="k">NULL</span><span class="p">,</span>
  <span class="o">`</span><span class="k">version</span><span class="o">`</span> <span class="nb">integer</span> <span class="k">NULL</span><span class="p">,</span>
  <span class="k">UNIQUE</span> <span class="k">INDEX</span> <span class="o">`</span><span class="n">migrate_version_pkey</span><span class="o">`</span> <span class="p">(</span><span class="o">`</span><span class="n">repository_id</span><span class="o">`</span><span class="p">)</span>
<span class="p">);</span>
</pre></div>

<hr>

<h4>You can merge this Pull Request by running:</h4>
<pre>  git pull https://github.com/kiwiroy/sql-translator postgres_indices_fix</pre>
<p>Or view, comment on, or merge it at:</p>
<p>&nbsp;&nbsp;<a href='https://github.com/dbsrgits/sql-translator/pull/24'>https://github.com/dbsrgits/sql-translator/pull/24</a></p>

<h4>Commit Summary</h4>
<ul>
  <li>add_index expects an array ref not a array ref of stringified array r…</li>
</ul>

<h4>File Changes</h4>
<ul>
  <li><strong>M</strong> lib/SQL/Translator/Parser/DBI/PostgreSQL.pm (3)</li>
</ul>

<h4>Patch Links</h4>
<ul>
  <li><a href='https://github.com/dbsrgits/sql-translator/pull/24.patch'>https://github.com/dbsrgits/sql-translator/pull/24.patch</a></li>
  <li><a href='https://github.com/dbsrgits/sql-translator/pull/24.diff'>https://github.com/dbsrgits/sql-translator/pull/24.diff</a></li>
</ul>


            <p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">
              &mdash;<br>
              Reply to this email directly or <a href='https://github.com/dbsrgits/sql-translator/pull/24'>view it on GitHub</a>.
            </p>
            <img src='https://github.com/notifications/beacon/4W3BWTo7EIi_7vx28Xzl_sX1U8MqTnYhOYW1CxeDjlBhWgnE1OEiRLKnXbnGZChD.gif' height='1' width='1'>