X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Fdunning_foreign_key_for_trans_id.sql;h=37fb3e7d938a1189d2e88f7c48e6aa2b8cbab8f1;hb=577042c61c5e1fffb8747079b4f9826e51532ee8;hp=e84892e8af964fca81ddc921b1911ea96df1be77;hpb=79c0cb3ee3c502c560d4b541eeb5e662fe50bbbd;p=kivitendo-erp.git

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 e84892e8a..37fb3e7d9 100644
--- 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