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 nomeata@debian.org | ICQ# 74513189 | GPG-Keyid: 4743206C JID: nomeata@joachim-breitner.de | http://people.debian.org/~nomeata
Attachment:
signature.asc
Description: This is a digitally signed message part