Mahnungs-Tabelle: Fremdschlüsselverknüpfung auf Rechnungstabelle Part 2

[kivitendo-erp.git] / sql / Pg-upgrade2 / dunning_foreign_key_for_trans_id.sql

diff --git a/sql/Pg-upgrade2/dunning_foreign_key_for_trans_id.sql b/sql/Pg-upgrade2/dunning_foreign_key_for_trans_id.sql
index e84892e..37fb3e7 100644 (file)
--- a/sql/Pg-upgrade2/dunning_foreign_key_for_trans_id.sql
+++ b/sql/Pg-upgrade2/dunning_foreign_key_for_trans_id.sql
@@ -6,6 +6,7 @@ WHERE NOT EXISTS (
   SELECT ar.id
   FROM ar
   WHERE ar.id = dunning.trans_id
+  LIMIT 1
 );
 
 ALTER TABLE dunning