Re: PACKAGESITE spam

On Thu, Dec 26, 2013 at 12:41:31PM +0100, Baptiste Daroussin wrote:
> On Thu, Dec 26, 2013 at 10:16:44PM +1100, Peter Jeremy wrote:
> > On 2013-Dec-22 11:53:17 -0800, Darren Pilgrim <list_freebsd_at_bluerosetech.com> wrote:
> > >Because of that deinstall log.  When you use `pkg install` to upgrade a 
> > >port, you get something like this:
> > >
> > >Jul 10 23:06:40 chombo pkg-static: ca_root_nss-3.15.1 installed
> > >Nov 29 15:04:52 chombo pkg: ca_root_nss reinstalled: 3.15.2_1
> > >
> > >That information does not exist in the pkg database.
> > 
> > I agree that's a serious bug/regression in the pkg database: With the
> > old pkg system, I could tell when a port was installed by looking at
> > the timestamps on the +COMMENT file.  The install time is needed to
> > answer questions like "does this entry in UPDATING affect me" (ie have
> > I rebuilt the port since the entry date).  It's something I used
> > regularly and its absence is a PITA.
> 
> You can still query from the package database about the installation time.
> 

How?

% pkg info | grep gcc
gcc-4.6.4                   GNU Compiler Collection 4.6
makedep-1.0.2_1             Create dependencies in makefiles using 'gcc -M'
% pkg query -F gcc-4.6.4 %t
pkg: archive_read_open_filename(gcc-4.6.4): Failed to open 'gcc-4.6.4'
% pkg query %t gcc-4.6.4
1387742889

Is that seconds since the epoch?  If yes, if may be prudent to add a
%T format, so one can easily determine that 1387742889 is Sun Dec 22
23:20:51 2013.

-- 
Steve