Hi again, On Thu, Apr 19, 2018 at 09:06:09AM +0200, Andreas Tille wrote: > Hi, > > if you are in CC of this mail please replace your e-mail address > in the named source package in Maintainer and Uploaders field since > the e-mail becomes invalid soon with the shutdown of Alioth.
the lists are definitely shorter if it is restricted to release='sid' which is the only thing we can change (and Ming Hua <[email protected]> does not need to change anything anymore - thanks for doing this pro-actively): Maintainers: udd=# select distinct source, maintainer from packages where release = 'sid' and maintainer like '%alioth.debian.org%' and maintainer not like '%lists.alioth.debian.org%' ; source | maintainer ---------------------+---------------------------------------------------- libglademm2.4 | Deng Xiyue <[email protected]> libgnomecanvasmm2.6 | Deng Xiyue <[email protected]> (2 Zeilen) Uploaders (here is even a duplicate, probably due to different arches): udd=# select distinct source, uploaders from sources where uploaders like '%alioth.debian.org%' and uploaders not like '%lists.alioth.debian.org%' and source not in ( select distinct source from packages where maintainer like '%alioth.debian.org%' and maintainer not like '%lists.alioth.debian.org%'); udd=# select distinct source, uploaders from sources where release = 'sid' and uploaders like '%alioth.debian.org%' and uploaders not like '%lists.alioth.debian.org%' and source not in ( select distinct source from packages where maintainer like '%alioth.debian.org%' and maintainer not like '%lists.alioth.debian.org%'); source | uploaders --------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------- atkmm1.6 | Deng Xiyue <[email protected]>, Michael Biebl <[email protected]>, Krzysztof Klimonda <[email protected]> autoconf-archive | Deng Xiyue <[email protected]> gsequencer | Joël Krähemann <[email protected]>, IOhannes m zmölnig (Debian/GNU) <[email protected]> gsequencer | Joël Krähemann <[email protected]>, IOhannes m zmölnig (Debian/GNU) <[email protected]>, libgtksourceviewmm | Deng Xiyue <[email protected]>, Josselin Mouette <[email protected]>, Michael Biebl <[email protected]> pangomm | Deng Xiyue <[email protected]>, Martin Pitt <[email protected]>, Michael Biebl <[email protected]>, Michael Casadevall <[email protected]> postgrey | Jon Daley <[email protected]> (7 Zeilen) Kind regards Andreas. > On Wed, Apr 18, 2018 at 10:09:40PM +0200, Alex Muntada wrote: > > > OTOH, there are some packages that have users.alioth.debian.org > > e-mail addresses in Maintainer and Uploaders, that may be worth > > dealing with. > > > udd=# select distinct source, maintainer from packages where maintainer like > '%alioth.debian.org%' and maintainer not like '%lists.alioth.debian.org%' ; > source | maintainer > ---------------------+---------------------------------------------------- > gconfmm2.6 | Deng Xiyue <[email protected]> > glibmm2.4 | Deng Xiyue <[email protected]> > gnome-vfsmm2.6 | Deng Xiyue <[email protected]> > gtkmm2.4 | Deng Xiyue <[email protected]> > gtkmm-documentation | Deng Xiyue <[email protected]> > libglademm2.4 | Deng Xiyue <[email protected]> > libgnomecanvasmm2.6 | Deng Xiyue <[email protected]> > libgnomemm2.6 | Deng Xiyue <[email protected]> > libgnomeuimm2.6 | Deng Xiyue <[email protected]> > libnotifymm | Deng Xiyue <[email protected]> > libxml++2.6 | Deng Xiyue <[email protected]> > scim-pinyin | Ming Hua <[email protected]> > scim-tables | Ming Hua <[email protected]> > scim-uim | Ming Hua <[email protected]> > (14 rows) > > I've added those two maintainers in CC. > > Similar with Uploaders (I've excluded in the list the sources that are > mentioned above): > > udd=# select distinct source, uploaders from sources where uploaders like > '%alioth.debian.org%' and uploaders not like '%lists.alioth.debian.org%' and > source not in ( select distinct source from packages where maintainer like > '%alioth.debian.org%' and maintainer not like '%lists.alioth.debian.org%'); > source | > uploaders > > --------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- > atkmm1.6 | Deng Xiyue <[email protected]>, > Michael Biebl <[email protected]>, Krzysztof Klimonda > <[email protected]> > autoconf-archive | Deng Xiyue <[email protected]> > glade-3 | Deng Xiyue <[email protected]>, > Josselin Mouette <[email protected]>, Loic Minier <[email protected]>, Michael > Biebl <[email protected]> > glade-3 | Deng Xiyue <[email protected]>, > Josselin Mouette <[email protected]>, Loic Minier <[email protected]>, Sebastian > Dröge <[email protected]> > gsequencer | Joël Krähemann > <[email protected]>, IOhannes m zmölnig (Debian/GNU) > <[email protected]> > gsequencer | Joël Krähemann > <[email protected]>, IOhannes m zmölnig (Debian/GNU) > <[email protected]>, > gtkmm3.0 | Deng Xiyue <[email protected]>, > Emilio Pozuelo Monfort <[email protected]>, Michael Biebl <[email protected]>, > Sebastian Dröge <[email protected]> > libgtksourceviewmm | Deng Xiyue <[email protected]>, > Josselin Mouette <[email protected]>, Michael Biebl <[email protected]> > libgtksourceviewmm | Deng Xiyue <[email protected]>, > Loic Minier <[email protected]>, Michael Biebl <[email protected]> > pangomm | Deng Xiyue <[email protected]>, > Martin Pitt <[email protected]>, Michael Biebl <[email protected]>, Michael > Casadevall <[email protected]> > pangomm | Deng Xiyue <[email protected]>, > Martin Pitt <[email protected]>, Michael Biebl <[email protected]>, Sebastian > Dröge <[email protected]>, Michael Casadevall <[email protected]> > pangomm | Deng Xiyue <[email protected]>, > Michael Biebl <[email protected]>, Sebastian Dröge <[email protected]>, Michael > Casadevall <[email protected]> > postgrey | Jon Daley <[email protected]> > scim | Osamu Aoki <[email protected]>, LI Daobing > <[email protected]>, Ming Hua <[email protected]> > scim-hangul | Ming Hua <[email protected]> > scim-m17n | Osamu Aoki <[email protected]>, Ming Hua > <[email protected]> > (16 Zeilen) > > > Kind regards > > Andreas. > > > -- > http://fam-tille.de > > -- http://fam-tille.de
