From owner-freebsd-pkg@FreeBSD.ORG  Mon Dec 22 04:26:16 2014
Return-Path: <owner-freebsd-pkg@FreeBSD.ORG>
Delivered-To: freebsd-pkg@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org
 [IPv6:2001:1900:2254:206a::19:1])
 (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits))
 (No client certificate requested)
 by hub.freebsd.org (Postfix) with ESMTPS id 1B72F7FD;
 Mon, 22 Dec 2014 04:26:16 +0000 (UTC)
Received: from mx5.roble.com (mx5.roble.com [206.40.34.5])
 (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))
 (Client CN "mx5.roble.com", Issuer "mx5.roble.com" (not verified))
 by mx1.freebsd.org (Postfix) with ESMTPS id 0A9E13801;
 Mon, 22 Dec 2014 04:26:15 +0000 (UTC)
Date: Sun, 21 Dec 2014 20:26:15 -0800 (PST)
From: Roger Marquis <marquis@roble.com>
To: freebsd-pkg@freebsd.org
Subject: Re: sqlite error while executing DROP INDEX
In-Reply-To: <20141221233828.GA43454@ivaldir.etoilebsd.net>
References: <mailman.88.1418990402.75002.freebsd-pkg@freebsd.org>
 <20141221194819.94F2FB59@hub.freebsd.org>
 <20141221233828.GA43454@ivaldir.etoilebsd.net>
User-Agent: Alpine 2.00 (BSF 1167 2008-08-23)
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
Cc: freebsd-ports@freebsd.org
X-BeenThere: freebsd-pkg@freebsd.org
X-Mailman-Version: 2.1.18-1
Precedence: list
List-Id: Binary package management and package tools discussion
 <freebsd-pkg.freebsd.org>
List-Unsubscribe: <https://lists.freebsd.org/mailman/options/freebsd-pkg>,
 <mailto:freebsd-pkg-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-pkg/>
List-Post: <mailto:freebsd-pkg@freebsd.org>
List-Help: <mailto:freebsd-pkg-request@freebsd.org?subject=help>
List-Subscribe: <https://lists.freebsd.org/mailman/listinfo/freebsd-pkg>,
 <mailto:freebsd-pkg-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 22 Dec 2014 04:26:16 -0000

Matthew Seaman wrote:
> Something like:
>   SELECT name, version, package_id FROM deps GROUP BY name, version,
>   package_id HAVING count(*) > 1 ;

That returns:

   pkgconf|0.8.7_2|7714

Though the server's daily 'pkg info' gave no indication this was multiply
installed.  Question now is how to remove the package or at least the
package's (index?) records using 'pkg shell'?

Roger