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