[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: Build time column via "psql wanna-build"



On Sun, Apr 21, 2013 at 23:51:57 +0200, Joachim Breitner wrote:

> Hi,
> 
> I was about to harvest some data from the "Build time" that I can see at,
> for example, https://buildd.debian.org/status/logs.php?pkg=ghc&arch=amd64,
> but it seems that I cannot access it using "psql wanna-build" on grieg:
> 
> wanna-build=> select * from log limit 1;
>  package | distribution |        version         |      timestamp      | architecture 
> ---------+--------------+------------------------+---------------------+--------------
>  wmii    | experimental | 3.10~20120413+hg2813-2 | 2013-04-21 21:47:43 | mips
> (1 Zeile)
> 
> From what I can tell log is a view using pkg_history, which I do not
> have access to:
> 
> wanna-build=> select * from pkg_history limit 1;
> ERROR:  permission denied for relation pkg_history
> 
wanna-build=> select * from amd64_public.pkg_history where package = 'ghc' limit 1;
 package | distribution | version |      timestamp      | result | build_time | disk_space |      builder      
---------+--------------+---------+---------------------+--------+------------+------------+-------------------
 ghc     | experimental | 7.0.1-1 | 2011-02-28 06:29:59 | failed |       3417 | 2159128576 | barber.debian.org
(1 row)

Cheers,
Julien

Attachment: signature.asc
Description: Digital signature


Reply to: