Re: Build time column via psql wanna-build
On Mon, Apr 22, 2013 at 08:43:10PM +0200, Joachim Breitner wrote: 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? Schemas are not listed by default. »\dn« lists all available schemas. »\d amd64.« lists all tables within the schema amd64. The other architecture schemas are alike. Kind regards Philipp Kern signature.asc Description: Digital signature
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=ghcarch=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
Re: Build time column via psql wanna-build
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=ghcarch=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
Build time column via psql wanna-build
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=ghcarch=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 Could someone add the fields build_time and disk_space to the definition of the view logs? Thanks, 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