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 <minghua-gu...@users.alioth.debian.org> 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 <manphiz-gu...@users.alioth.debian.org> libgnomecanvasmm2.6 | Deng Xiyue <manphiz-gu...@users.alioth.debian.org> (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 <manphiz-gu...@users.alioth.debian.org>, Michael Biebl <bi...@debian.org>, Krzysztof Klimonda <kklimo...@syntaxhighlighted.com> autoconf-archive | Deng Xiyue <manphiz-gu...@users.alioth.debian.org> gsequencer | Joël Krähemann <jkraehemann-gu...@users.alioth.debian.org>, IOhannes m zmölnig (Debian/GNU) <umlae...@debian.org> gsequencer | Joël Krähemann <jkraehemann-gu...@users.alioth.debian.org>, IOhannes m zmölnig (Debian/GNU) <umlae...@debian.org>, libgtksourceviewmm | Deng Xiyue <manphiz-gu...@users.alioth.debian.org>, Josselin Mouette <j...@debian.org>, Michael Biebl <bi...@debian.org> pangomm | Deng Xiyue <manphiz-gu...@users.alioth.debian.org>, Martin Pitt <mp...@debian.org>, Michael Biebl <bi...@debian.org>, Michael Casadevall <sonicmcta...@gmail.com> postgrey | Jon Daley <jondaley-gu...@alioth.debian.org> (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 <manphiz-gu...@users.alioth.debian.org> > glibmm2.4 | Deng Xiyue <manphiz-gu...@users.alioth.debian.org> > gnome-vfsmm2.6 | Deng Xiyue <manphiz-gu...@users.alioth.debian.org> > gtkmm2.4 | Deng Xiyue <manphiz-gu...@users.alioth.debian.org> > gtkmm-documentation | Deng Xiyue <manphiz-gu...@users.alioth.debian.org> > libglademm2.4 | Deng Xiyue <manphiz-gu...@users.alioth.debian.org> > libgnomecanvasmm2.6 | Deng Xiyue <manphiz-gu...@users.alioth.debian.org> > libgnomemm2.6 | Deng Xiyue <manphiz-gu...@users.alioth.debian.org> > libgnomeuimm2.6 | Deng Xiyue <manphiz-gu...@users.alioth.debian.org> > libnotifymm | Deng Xiyue <manphiz-gu...@users.alioth.debian.org> > libxml++2.6 | Deng Xiyue <manphiz-gu...@users.alioth.debian.org> > scim-pinyin | Ming Hua <minghua-gu...@users.alioth.debian.org> > scim-tables | Ming Hua <minghua-gu...@users.alioth.debian.org> > scim-uim | Ming Hua <minghua-gu...@users.alioth.debian.org> > (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 <manphiz-gu...@users.alioth.debian.org>, > Michael Biebl <bi...@debian.org>, Krzysztof Klimonda > <kklimo...@syntaxhighlighted.com> > autoconf-archive | Deng Xiyue <manphiz-gu...@users.alioth.debian.org> > glade-3 | Deng Xiyue <manphiz-gu...@users.alioth.debian.org>, > Josselin Mouette <j...@debian.org>, Loic Minier <l...@dooz.org>, Michael > Biebl <bi...@debian.org> > glade-3 | Deng Xiyue <manphiz-gu...@users.alioth.debian.org>, > Josselin Mouette <j...@debian.org>, Loic Minier <l...@dooz.org>, Sebastian > Dröge <sl...@debian.org> > gsequencer | Joël Krähemann > <jkraehemann-gu...@users.alioth.debian.org>, IOhannes m zmölnig (Debian/GNU) > <umlae...@debian.org> > gsequencer | Joël Krähemann > <jkraehemann-gu...@users.alioth.debian.org>, IOhannes m zmölnig (Debian/GNU) > <umlae...@debian.org>, > gtkmm3.0 | Deng Xiyue <manphiz-gu...@users.alioth.debian.org>, > Emilio Pozuelo Monfort <po...@debian.org>, Michael Biebl <bi...@debian.org>, > Sebastian Dröge <sl...@debian.org> > libgtksourceviewmm | Deng Xiyue <manphiz-gu...@users.alioth.debian.org>, > Josselin Mouette <j...@debian.org>, Michael Biebl <bi...@debian.org> > libgtksourceviewmm | Deng Xiyue <manphiz-gu...@users.alioth.debian.org>, > Loic Minier <l...@dooz.org>, Michael Biebl <bi...@debian.org> > pangomm | Deng Xiyue <manphiz-gu...@users.alioth.debian.org>, > Martin Pitt <mp...@debian.org>, Michael Biebl <bi...@debian.org>, Michael > Casadevall <sonicmcta...@gmail.com> > pangomm | Deng Xiyue <manphiz-gu...@users.alioth.debian.org>, > Martin Pitt <mp...@debian.org>, Michael Biebl <bi...@debian.org>, Sebastian > Dröge <sl...@debian.org>, Michael Casadevall <sonicmcta...@gmail.com> > pangomm | Deng Xiyue <manphiz-gu...@users.alioth.debian.org>, > Michael Biebl <bi...@debian.org>, Sebastian Dröge <sl...@debian.org>, Michael > Casadevall <sonicmcta...@gmail.com> > postgrey | Jon Daley <jondaley-gu...@alioth.debian.org> > scim | Osamu Aoki <os...@debian.org>, LI Daobing > <lidaob...@debian.org>, Ming Hua <minghua-gu...@users.alioth.debian.org> > scim-hangul | Ming Hua <minghua-gu...@users.alioth.debian.org> > scim-m17n | Osamu Aoki <os...@debian.org>, Ming Hua > <minghua-gu...@users.alioth.debian.org> > (16 Zeilen) > > > Kind regards > > Andreas. > > > -- > http://fam-tille.de > > -- http://fam-tille.de