projects / kivitendo-erp.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: c89986a) | patch
Upgrade-Scripte zum Löschen von CVars via Trigger beschleunigt.
authorBernd Bleßmann <bernd@kivitendo-premium.de>
Mon, 24 Nov 2014 11:50:58 +0000 (12:50 +0100)
committerBernd Bleßmann <bernd@kivitendo-premium.de>
Mon, 24 Nov 2014 11:50:58 +0000 (12:50 +0100)
commitdbd67e4387f1d33ce1ffdc505fad7fdd0eee7f29
tree4fa17c41dcd5e0bcc17a5091386860e867912306tree | snapshot
parentc89986ac6447c14ebf351047b9441bcbf5637e76commit | diff
Upgrade-Scripte zum Löschen von CVars via Trigger beschleunigt.

In den queries, die vor dem Installieren der Trigger die DB aufräumen,
"NOT IN" durch "NOT EXISTS" ersetzt.

Hintergrund-Info ist hier zu finden:
http://explainextended.com/2009/09/16/not-in-vs-not-exists-vs-left-join-is-null-postgresql/
(Dank an Sven)
sql/Pg-upgrade2/custom_variables_delete_via_trigger.pl diff | blob | history
sql/Pg-upgrade2/custom_variables_delete_via_trigger_2.pl diff | blob | history
sql/Pg-upgrade2/delete_cvars_on_trans_deletion.sql diff | blob | history
Unnamed repository; edit this file 'description' to name the repository.