Re: some UDD schema changes

2009-07-19 Thread Enrico Zini
On Thu, Jul 16, 2009 at 04:28:57PM -0400, Lucas Nussbaum wrote: > - all_packages_distrelcomparch (which was a hack) was replaced by two > different tables (for Debian and Ubuntu) and a > all_packages_distrelcomparch view. It looks like some permission is missing: d...@merkel:/srv/dde.debian.ne

Re: some UDD schema changes

2009-07-19 Thread Enrico Zini
On Sun, Jul 19, 2009 at 10:08:51AM +0100, Enrico Zini wrote: > > - all_packages_distrelcomparch (which was a hack) was replaced by two > > different tables (for Debian and Ubuntu) and a > > all_packages_distrelcomparch view. > > It looks like some permission is missing: > > d...@merkel:/srv/dd

Re: some UDD schema changes

2009-07-19 Thread Enrico Zini
On Thu, Jul 16, 2009 at 04:28:57PM -0400, Lucas Nussbaum wrote: > However, turning release into an ENUM required changes in related tables > (packages and packages_summary), and the only way to sanely apply them > was to drop the table and create them again. Which I did, so the tables > are fillin

Bug#264774: Debian wnpp bugs auto-close script

2009-07-19 Thread Niels Thykier
Hi I have been trying to reach "David Moreno Garza ", however the email is no longer valid. Doing a little google search I am guessing that "da...@debina.org" is your new email address. If this is not the case, please disregard this email. There has been a long wish for a script that could assi

Re: some UDD schema changes

2009-07-19 Thread Jonathan Yu
Hi: On Thu, Jul 16, 2009 at 4:28 PM, Lucas Nussbaum wrote: > Hi, > > I've squashed a few items off my TODO list about UDD. I did the > following changes: > > - 'release' columns are now ENUMs everywhere. This allows to compare two >  releases ('etch' < 'squeeze') or to order by release. Oh, very n

Re: some UDD schema changes

2009-07-19 Thread Lucas Nussbaum
On 19/07/09 at 10:58 +0100, Enrico Zini wrote: > On Thu, Jul 16, 2009 at 04:28:57PM -0400, Lucas Nussbaum wrote: > > > However, turning release into an ENUM required changes in related tables > > (packages and packages_summary), and the only way to sanely apply them > > was to drop the table and c

Re: some UDD schema changes

2009-07-19 Thread Lucas Nussbaum
On 19/07/09 at 10:17 +0100, Enrico Zini wrote: > On Sun, Jul 19, 2009 at 10:08:51AM +0100, Enrico Zini wrote: > > > > - all_packages_distrelcomparch (which was a hack) was replaced by two > > > different tables (for Debian and Ubuntu) and a > > > all_packages_distrelcomparch view. > > > > It lo

Re: some UDD schema changes

2009-07-19 Thread Lucas Nussbaum
On 19/07/09 at 09:00 -0400, Jonathan Yu wrote: > Hi: > > On Thu, Jul 16, 2009 at 4:28 PM, Lucas Nussbaum > wrote: > > Hi, > > > > I've squashed a few items off my TODO list about UDD. I did the > > following changes: > > > > - 'release' columns are now ENUMs everywhere. This allows to compare two

Bug#523249: qa.debian.org: Popcon sorts alphabetically.

2009-07-19 Thread Niels Thykier
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi I have had a look at it and I think the issue is that one of the packages[1] listed have a popcon value "-". When ordering is not "3", then it is listed in a different table (further down), which suffers from the same problem. ~Niels [1] "mozilla

Bug#462470: marked as done (PTS: don't show changelog-only ubuntu patches)

2009-07-19 Thread Debian Bug Tracking System
Your message dated Sun, 19 Jul 2009 23:55:47 +0200 with message-id <4a639663.9050...@thykier.net> and subject line Closing has caused the Debian Bug report #462470, regarding PTS: don't show changelog-only ubuntu patches to be marked as done. This means that you claim that the problem has been de

Re: some UDD schema changes

2009-07-19 Thread Jonathan Yu
On Sun, Jul 19, 2009 at 11:45 AM, Lucas Nussbaum wrote: > On 19/07/09 at 09:00 -0400, Jonathan Yu wrote: >> Hi: >> >> On Thu, Jul 16, 2009 at 4:28 PM, Lucas Nussbaum >> wrote: >> > Hi, >> > >> > I've squashed a few items off my TODO list about UDD. I did the >> > following changes: >> > >> > - 're