Hi Andreas, > Hi Lucas, > > is there any good reason to "drop view all_sources"[1]. I'm using this > for team-metrics and while I could probably re-implement it somehow I > would like to learn about the motivation first.
This also came up on IRC a few days ago. I removed that view because there was no use for it internally (in UDD-hosted tools) and it was a bit painful to update when the sources schema changed. It was defined as the equivalent of: SELECT * FROM sources -- that's Debian's source packages UNION SELECT * FROM ubuntu_sources -- that's Ubuntu's UNION SELECT * FROM derivatives_sources; What is your use case for it? Usually, you don't want to scan through all those sources (Debian+Ubuntu+...) at the same time without differenciating based on the distribution. I suspected that you want to use 'sources' instead (or 'sources_uniq' if you prefer to hide some superseded packages that are still in Debian's Sources files). Lucas
