fixed problem with invalid trigger when deleting entries from backup_parts

[BackupPC.git] / sql / 09_backup_parts_trigger.sql

diff --git a/sql/09_backup_parts_trigger.sql b/sql/09_backup_parts_trigger.sql
index c4fe684..c48163c 100644 (file)
--- a/sql/09_backup_parts_trigger.sql
+++ b/sql/09_backup_parts_trigger.sql
@@ -32,23 +32,25 @@ create trigger do_backup_parts_check
 create or replace function backup_backup_parts_check() returns trigger as '
 declare
        b_id            integer;
+       old_b_id        integer;
        my_part_nr      integer;
        calc_part       integer;
 begin
        if (TG_OP = ''INSERT'') then
-               -- raise notice ''trigger: % backup_id %'', TG_OP, new.backup_id;
+               raise notice ''trigger: % backup_id %'', TG_OP, new.backup_id;
                b_id = new.backup_id;
                my_part_nr = new.part_nr;
                execute ''update backups set parts = parts + 1 where id = '' || b_id;
        elsif (TG_OP = ''DELETE'') then
-               -- raise notice ''trigger: % backup_id %'', TG_OP, old.backup_id;
+               raise notice ''trigger: % backup_id %, old.part_nr %'', TG_OP, old.backup_id, old.part_nr;
                b_id = old.backup_id;
-               my_part_nr = old.part_nr;
+               my_part_nr = old.part_nr - 1;
                execute ''update backups set parts = parts - 1 where id = '' || b_id;
        end if;
        calc_part := (select count(part_nr) from backup_parts where backup_id = b_id);
-       if ( my_part_nr != calc_part ) then
-               raise exception ''Update of backup_parts with backup_id % aborted, requested part_nr is % and calulated next is %'', b_id, my_part_nr, calc_part;
+       if ( my_part_nr != calc_part ) then 
+       raise exception ''Update of backup_parts with backup_id % aborted, requested part_nr is % and calulated next is %'', b_id, my_part_nr, calc_part;
+       
        end if;
        return null;
 end;