X-Git-Url: https://pd.if.org/git/?a=blobdiff_plain;f=schema%2Fsyncinfo.sql;fp=schema%2Fsyncinfo.sql;h=cbdffce45ba2018b8e06ca70162bb806a5d717d0;hb=28ff0abf216c03268efedb6d43eb2d3e04c3e8aa;hp=6739cce2a731ec28c51418da9e253a5fd803334b;hpb=4e2e7c3d2780fdca649cb084523750f27afa5542;p=zpackage diff --git a/schema/syncinfo.sql b/schema/syncinfo.sql index 6739cce..cbdffce 100644 --- a/schema/syncinfo.sql +++ b/schema/syncinfo.sql @@ -75,9 +75,6 @@ PC.status not in ('installed','removing','updating') ) */ --- every path in updating and removing is either remove or no-op --- not true, could be an update, but should be handled above - union select case @@ -114,7 +111,6 @@ where P.status = 'installing' --and PFC.path is not null - -- every path in updating and removing is either remove or no-op -- not true, could be an update, but should be handled above union @@ -144,6 +140,7 @@ not exists (select path from where PFI.path = PFR.path ) +and path not in (select path from preserve) -- paths in 'installed' or 'updated' are no-ops