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.
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.