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	dpavlin	273	-- 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