> I'm pretty sure that the normal way of working for an SQL engine is to > always use a higher number when creating new records. That's how the > serial type in PostgreSQL works. I don't think an RDBMS tries to
My experience is the same with MySQL: MediaIDs of deleted volumes aren't reused. A new volume gets a MediaID higher than the highest one ever used. Regards, Robert -------------------------------------------------------- Robert Wirth, Stuhlsatzenhausweg 3, D-66123 Saarbruecken @office: +49-681-302-5078/5572 ++ @fax: +49-681-302-5341 mailto:[EMAIL PROTECTED] ++ http://www.dfki.de/~wirth -------------------------------------------------------- _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users