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	dpavlin	173	-- 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) ;