Re: [UDD] Improved link between LP bug tasks watching Debian bugs and debbugs ids
On 04/08/10 at 19:28 +0200, Andreas Tille wrote:
> On Wed, Aug 04, 2010 at 06:29:02PM +0200, Olivier Berger wrote:
> > I'd suggest to add a table like :
> >
> > CREATE TABLE whatever AS
> > SELECT bug, int4(substring(watch from 'http://bugs.debian.org/cgi-bin/bugreport\\.cgi\\?bug=(\\d+)')) as debian_bugid
> > FROM ubuntu_bugs_tasks WHERE
> > watch LIKE 'http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=%';
> >
> > ...
> >
> > Any comments ?
>
> Sounds reasonable
Couldn't this be simply done as a VIEW ? Or is it too
performance-critical?
--
| Lucas Nussbaum
| lucas@lucas-nussbaum.net http://www.lucas-nussbaum.net/ |
| jabber: lucas@nussbaum.fr GPG: 1024D/023B3F4F |
Reply to: