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

2013-04-22 Thread Joachim Breitner
Hi,

Am Montag, den 22.04.2013, 20:06 +0200 schrieb Julien Cristau:
> On Sun, Apr 21, 2013 at 23:51:57 +0200, Joachim Breitner wrote:
> > 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)

thanks. Is there a reason why this table (or view) is not shown with
"\d" (otherwise, I might have found it myself)? Also, is there a
combined table of build logs that contains this field?

Greetings,
Joachim

-- 
Joachim "nomeata" Breitner
Debian Developer
  nome...@debian.org | ICQ# 74513189 | GPG-Keyid: 4743206C
  JID: nome...@joachim-breitner.de | http://people.debian.org/~nomeata



signature.asc
Description: This is a digitally signed message part


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

2013-04-22 Thread Julien Cristau
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


signature.asc
Description: Digital signature