[midPoint] PostgreSQL indexes

Gustavo J Gallardo ggallard at identicum.com
Wed Apr 26 18:08:41 CEST 2017


Hi all,
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).

In which file(s) should I commit (and then pull request) these changes:

/midpoint/config/sql/_all/postgresql-3.5-all.sql
/midpoint/config/sql/_all/postgresql-upgrade-3.4-3.5-all.sql

/midpoint/config/sql/midpoint/3.5/postgresql/postgresql-3.5-all.sql
/midpoint/config/sql/midpoint/3.5/postgresql/postgresql-upgrade-3.4-3.5-all.sql

/midpoint/config/sql/midpoint/3.6/postgresql/postgresql-3.6-all.sql
/midpoint/config/sql/midpoint/3.6/postgresql/postgresql-upgrade-3.5-3.6-all.sql

Is there any type of automatic process to e.g. merge the .../midpoint/...
files into .../_all/... files?


Thanks,

GJG
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20170426/6c52443a/attachment.htm>


More information about the midPoint mailing list