trunk/sql/02_fix_found_in_db.sql

-- fix database to repair found_in_db bug fixed in r74

--delete from files where id not in (
--      select distinct on(shareid,path,date,size) id
--      from files
--      order by shareid,path,date,size,backupnum asc
--);

-- Below is alternative implementation which seems much faster for me.
-- You must manually COMMIT your transaction to make changes permanent.

begin ;
select distinct on(shareid,path,date,size) id into temp okids from files order by shareid,path,date,size,backupnum asc;
delete from files where id not in (select id from okids) ;
1	-- fix database to repair found_in_db bug fixed in r74
2
3	--delete from files where id not in (
4	-- select distinct on(shareid,path,date,size) id
5	-- from files
6	-- order by shareid,path,date,size,backupnum asc
7	--);
8
9	-- Below is alternative implementation which seems much faster for me.
10	-- You must manually COMMIT your transaction to make changes permanent.
11
12	begin ;
13	select distinct on(shareid,path,date,size) id into temp okids from files order by shareid,path,date,size,backupnum asc;
14	delete from files where id not in (select id from okids) ;