trunk/sql/zz_archive_delete_pending.sql

-- this snippet will erase all DVD media after 13th one!

begin ;

select id,dvd_nr,total_size,username from archive order by dvd_nr;

delete from archive where dvd_nr > 13 ;

select id,dvd_nr,total_size,username from archive order by dvd_nr;

select setval('dvd_nr', (select max(dvd_nr) from archive)) ;

1	-- this snippet will erase all DVD media after 13th one!
2
3	begin ;
4
5	select id,dvd_nr,total_size,username from archive order by dvd_nr;
6
7	delete from archive where dvd_nr > 13 ;
8
9	select id,dvd_nr,total_size,username from archive order by dvd_nr;
10
11	select setval('dvd_nr', (select max(dvd_nr) from archive)) ;
12