From owner-freebsd-ports@FreeBSD.ORG  Thu Aug 22 17:18:22 2013
Return-Path: <owner-freebsd-ports@FreeBSD.ORG>
Delivered-To: ports@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115])
 (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits))
 (No client certificate requested)
 by hub.freebsd.org (Postfix) with ESMTP id 422BE5E5;
 Thu, 22 Aug 2013 17:18:22 +0000 (UTC) (envelope-from yuri@rawbw.com)
Received: from shell0.rawbw.com (shell0.rawbw.com [198.144.192.45])
 by mx1.freebsd.org (Postfix) with ESMTP id 2E5B62D11;
 Thu, 22 Aug 2013 17:18:21 +0000 (UTC)
Received: from eagle.yuri.org (stunnel@localhost [127.0.0.1])
 (authenticated bits=0)
 by shell0.rawbw.com (8.14.4/8.14.4) with ESMTP id r7MHILYQ081472;
 Thu, 22 Aug 2013 10:18:21 -0700 (PDT) (envelope-from yuri@rawbw.com)
Message-ID: <521647DD.1040007@rawbw.com>
Date: Thu, 22 Aug 2013 10:18:21 -0700
From: Yuri <yuri@rawbw.com>
User-Agent: Mozilla/5.0 (X11; FreeBSD amd64;
 rv:17.0) Gecko/20130628 Thunderbird/17.0.7
MIME-Version: 1.0
To: Bryan Drewery <bdrewery@freebsd.org>
Subject: Re: pkgng+portmaster: portmaster erased the field packages.time
References: <521453CD.5030005@rawbw.com> <5215FACB.4060202@FreeBSD.org>
In-Reply-To: <5215FACB.4060202@FreeBSD.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Cc: "ports@freebsd.org" <ports@freebsd.org>
X-BeenThere: freebsd-ports@freebsd.org
X-Mailman-Version: 2.1.14
Precedence: list
List-Id: Porting software to FreeBSD <freebsd-ports.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/options/freebsd-ports>,
 <mailto:freebsd-ports-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-ports>
List-Post: <mailto:freebsd-ports@freebsd.org>
List-Help: <mailto:freebsd-ports-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
 <mailto:freebsd-ports-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 22 Aug 2013 17:18:22 -0000

On 08/22/2013 04:49, Bryan Drewery wrote:
> By "Packages.time" I assume you mean the timestamp the package was
> installed? There is no "conversion" timestamp stored by pkgng.

After pkg2ng has ran, all fields packages.time were !=null. This was 
probably the original install time then.

>
> How are you seeing this timestamp? With 'pkg query "%o %t"'?

I use firefox plugin to look into .sqlite file directly.

>
> Portmaster itself is not modifying this data at all (it can't), only
> pkgng updates this timestamp.


After portmaster ran, I observed all package.time fields became null, 
except for the ones updated by portmaster.
I am not sure who deleted them, this is what happened after portmaster ran.

Yuri