[UDD] Scope of tables derivatives_{packages,sources}

2010-02-20 Thread Andreas Tille
Hi, I'm about to import Debian Edu / Skolelinux extensions to Debian from http://ftp.skolelinux.org/skolelinux/dists/ into UDD to enable more complete Debian Edu tasks pages. When looking at current UDD I realised that Sidux packages are kept in tables derivatives_{packages,sources} while Ubunt

Re: [UDD] Scope of tables derivatives_{packages,sources}

2010-02-20 Thread Lucas Nussbaum
On 20/02/10 at 15:36 +0100, Andreas Tille wrote: > Hi, > > I'm about to import Debian Edu / Skolelinux extensions to Debian from > http://ftp.skolelinux.org/skolelinux/dists/ > into UDD to enable more complete Debian Edu tasks pages. When looking > at current UDD I realised that Sidux packages

Re: Permissions to create temporary tables

2010-02-20 Thread Lucas Nussbaum
On 19/02/10 at 11:45 +0100, Andreas Tille wrote: > On Mon, Feb 08, 2010 at 11:09:43AM +0100, Andreas Tille wrote: > > I want to hear your opinion about > >udd/sql/versions_archs_components.sql > > which creates a temporary table in a function which is not allowed to > > any user. Do we want to

Re: UDD content broken / alioth files on past versions

2010-02-20 Thread Lucas Nussbaum
On 08/02/10 at 11:09 +0100, Andreas Tille wrote: > Hi, > > I just realised that UDD is in a quite incomplete state. Several > packages are missing. Please give examples. > I also relaised that our webtools which are > building Blends tasks pages are at a version from July last year. Is > this

Re: UDD content broken / alioth files on past versions

2010-02-20 Thread Andreas Tille
On Sat, Feb 20, 2010 at 03:55:16PM +0100, Lucas Nussbaum wrote: > > I just realised that UDD is in a quite incomplete state. Several > > packages are missing. > > Please give examples. Problem vanished. > > I also relaised that our webtools which are > > building Blends tasks pages are at a ve

Re: [UDD] Scope of tables derivatives_{packages,sources}

2010-02-20 Thread Andreas Tille
On Sat, Feb 20, 2010 at 03:51:49PM +0100, Lucas Nussbaum wrote: > I'd say use derivatives_*, since the number of affected packages is > going to be very small. OK, this was also my preference. Meta-Comment: We need some way to document such things for UDD - or missed I something? Kind regards

Re: Permissions to create temporary tables

2010-02-20 Thread Andreas Tille
On Sat, Feb 20, 2010 at 04:05:56PM +0100, Lucas Nussbaum wrote: > > /*** > > * Obtain available versions in different releases for a given package > >* > > * This function takes a package name as argumen

Re: [UDD] Scope of tables derivatives_{packages,sources}

2010-02-20 Thread Lucas Nussbaum
On 20/02/10 at 16:29 +0100, Andreas Tille wrote: > On Sat, Feb 20, 2010 at 03:51:49PM +0100, Lucas Nussbaum wrote: > > I'd say use derivatives_*, since the number of affected packages is > > going to be very small. > > OK, this was also my preference. > > Meta-Comment: We need some way to documen

Different descriptions on different architectures for same package with same version in Lenny

2010-02-20 Thread Andreas Tille
Hi, I tried to track down the reason for having more than one description translations in DDTP for very same package in Lenny. Here is a strange example which makes me curious: # SELECT package, version, architecture, description from packages where package = 'openjdk-6-jre' and version

Re: Different descriptions on different architectures for same package with same version in Lenny

2010-02-20 Thread James Vega
On Sat, Feb 20, 2010 at 2:28 PM, Andreas Tille wrote: > #  SELECT package, version, architecture, description from packages >      where package = 'openjdk-6-jre' and version = '6b11-9.1' >      and distribution = 'debian' and release = 'lenny' and component = 'main'; >    package    | version  |

Re: Different descriptions on different architectures for same package with same version in Lenny

2010-02-20 Thread Stefano Zacchiroli
On Sat, Feb 20, 2010 at 08:28:55PM +0100, Andreas Tille wrote: > I really wonder how we might get different descriptions if the packages > are supposed to come from the same source package. > > Any reasonable explanation for this? James already replied with the specific details of this package.