Comment 1 for bug 1849742

Revision history for this message
Paul Collins (pjdc) wrote :

Here's a workaround (possibly not optimal, but explain seemed OK and it returned quickly:

launchpad_prod=# select person.name as owner, product.name as project, gitrepository.name as repo from gitrepository,person,product where gitrepository.id = 30355 and gitrepository.owner = person.id and gitrepository.project = product.id;
      owner | project | repo
-----------------+--------------------+--------------------
 ubuntu-security | ubuntu-cve-tracker | ubuntu-cve-tracker
(1 row)

launchpad_prod=# _

But it would certainly be more convenient if this information were closer to hand.