From owner-freebsd-pkg@FreeBSD.ORG  Mon Dec 22 15:25:03 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 8383FD9E;
 Mon, 22 Dec 2014 15:25:03 +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 6701DB8A;
 Mon, 22 Dec 2014 15:25:03 +0000 (UTC)
Date: Mon, 22 Dec 2014 07:25:03 -0800 (PST)
From: Roger Marquis <marquis@roble.com>
To: Baptiste Daroussin <bapt@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; format=flowed; charset=US-ASCII
Cc: freebsd-ports@freebsd.org, freebsd-pkg@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 15:25:03 -0000

Baptiste Daroussin wrote:
> The way to fix is:
> sqlite3 /var/db/pkg/local.sqlite "delete from deps where origin='devel/pkg-config';"
> Then everything should be back to normal

That worked!  Merci Baptiste and Matthew,
Roger