sqlite error while executing DROP INDEX

[Roger Marquis]

Matthew Seaman wrote:
> SELECT * FROM DEPS WHERE name='pkgconf' AND version='0.8.7_2'
>   AND package_id='7714';
> Given two rows that are exactly the same

No two rows but it apears one of pkg's dependencies may have changed
names at some point:

   # SELECT * FROM DEPS WHERE name='pkgconf' AND version='0.8.7_2'
   #   AND package_id='7714';

   devel/pkgconf|pkgconf|0.8.7_2|7714

   # SELECT * FROM DEPS WHERE name='pkgconf' AND version='0.8.7_2';

   devel/pkg-config|pkgconf|0.8.7_2|7669
   devel/pkg-config|pkgconf|0.8.7_2|7670
   devel/pkg-config|pkgconf|0.8.7_2|7671
   devel/pkg-config|pkgconf|0.8.7_2|7685
   devel/pkg-config|pkgconf|0.8.7_2|7686
   devel/pkgconf|pkgconf|0.8.7_2|7700
   devel/pkgconf|pkgconf|0.8.7_2|7714
   devel/pkg-config|pkgconf|0.8.7_2|7714
   devel/pkgconf|pkgconf|0.8.7_2|7747
   devel/pkgconf|pkgconf|0.8.7_2|7748
   devel/pkg-config|pkgconf|0.8.7_2|7755
   devel/pkg-config|pkgconf|0.8.7_2|7756
   devel/pkg-config|pkgconf|0.8.7_2|7772
   devel/pkg-config|pkgconf|0.8.7_2|7775
   devel/pkgconf|pkgconf|0.8.7_2|7798
   devel/pkgconf|pkgconf|0.8.7_2|7800
   devel/pkgconf|pkgconf|0.8.7_2|7802
   devel/pkg-config|pkgconf|0.8.7_2|7804

Can all of these records can be safely deleted, all of the pkg-configs,
or should the delete be limited to pkg-config|7714?  Also curious about
the significance of the package_id field and how n+1 records were written
in the first place.  I trust someone has filed one or more bugzillas as
it appears pkg should be checking for dupes on at least two dimensions.

Forensics is also hampered by the lack of a date field, ideally
reflecting the package's install date (with epoch/unix timestamp
precision).  Consider this a feature request.

Grazie!
Roger