<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>Hello Gustavo,</p>
<p>thank you for the contribution. <br>
</p>
<p>I would suggest to modify files in
/midpoint/config/sql/midpoint/3.6/postgresql/ directory.</p>
<p>Before 3.6 release, we will update files in the "_all" directory
accordingly. (We do it by hand.)</p>
<p>The files in 3.5 directory need not be updated. Unless you would
like to make this improvement a part of support-3.5 branch. In
that case you could update _all/postgresql and
midpoint/3.5/postgresql/ files as well (and cherry-pick
appropriate changes to support-3.5 branch).</p>
<p>Best regards,<br>
</p>
<pre class="moz-signature" cols="72">Pavol Mederly
Software developer
evolveum.com
</pre>
<div class="moz-cite-prefix">On 26.04.2017 18:08, Gustavo J Gallardo
wrote:<br>
</div>
<blockquote
cite="mid:CAA68kP8j=ffZqdVSwGRtO_Ex33VpUjWQ=rq4vBVCSBtF4_wfqw@mail.gmail.com"
type="cite">
<div dir="ltr">Hi all,
<div>we have a number of indexes to add to the SQL files, mainly
indexes for foreign keys (unlike Oracle and other databases,
PostgreSQL does not create an index automatically when a
foreign key is defined).</div>
<div><br>
</div>
<div>In which file(s) should I commit (and then pull request)
these changes:</div>
<div><br>
</div>
<div>/midpoint/config/sql/_all/postgresql-3.5-all.sql</div>
<div>/midpoint/config/sql/_all/postgresql-upgrade-3.4-3.5-all.sql<br>
</div>
<div>
<div><br>
</div>
<div>/midpoint/config/sql/midpoint/3.5/postgresql/postgresql-3.5-all.sql</div>
<div>/midpoint/config/sql/midpoint/3.5/postgresql/postgresql-upgrade-3.4-3.5-all.sql</div>
</div>
<div><br>
</div>
<div>
<div>/midpoint/config/sql/midpoint/3.6/postgresql/postgresql-3.6-all.sql</div>
<div>/midpoint/config/sql/midpoint/3.6/postgresql/postgresql-upgrade-3.5-3.6-all.sql</div>
</div>
<div><br>
</div>
<div>Is there any type of automatic process to e.g. merge the
.../midpoint/... files into .../_all/... files?</div>
<div><br>
</div>
<div><br>
</div>
<div>Thanks,</div>
<div><br>
</div>
<div>GJG</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
midPoint mailing list
<a class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a class="moz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<br>
</body>
</html>