From nobody Thu Apr 07 06:54:06 2022 X-Original-To: freebsd-pkg@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id D6C261A87C6A for ; Thu, 7 Apr 2022 06:54:08 +0000 (UTC) (envelope-from bapt@FreeBSD.org) Received: from smtp.freebsd.org (smtp.freebsd.org [IPv6:2610:1c1:1:606c::24b:4]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "smtp.freebsd.org", Issuer "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4KYsYX5dpDz4tnZ; Thu, 7 Apr 2022 06:54:08 +0000 (UTC) (envelope-from bapt@FreeBSD.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1649314448; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: in-reply-to:in-reply-to:references:references; bh=TDQ6osUiAVsRJgGByAVUvlyHTvqCOuuc8vXr2K8v3o8=; b=AujBOUHKJw+Wn5klZTlwAst5qWtcOs5MS8hVAT+IyD2I16ulJ+W13nSb0AM50jvywVnajR 8sBxUxlsDRQuqn2tVrTyZQT88+W4CsQlaqEJ8Rt8favhpBH1DkM0FZPKbvnC27qyfMpv2T dbvDCwVPoKizJMt0PBADH2kwLuok7EHqfjAAGz8la+jeCRmdcfvJCXWdrK/18ssW6JBMAA Wu7VbTd/hjEenhyTNHX0YBanlC0LMhXU5vxUnbluKisO6DX/sthmwPDOtobQ6/+lKr21bX Ie7GUnnuHVKL2thLzcfD5Qak1Gqt8ZrOVv97NbtuB/N181bLfsTSR43r9trsJA== Received: from aniel.nours.eu (nours.eu [176.31.115.77]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) (Authenticated sender: bapt) by smtp.freebsd.org (Postfix) with ESMTPSA id 89A03A052; Thu, 7 Apr 2022 06:54:08 +0000 (UTC) (envelope-from bapt@FreeBSD.org) Received: by aniel.nours.eu (Postfix, from userid 1001) id 9EE9B76880; Thu, 7 Apr 2022 08:54:06 +0200 (CEST) Date: Thu, 7 Apr 2022 08:54:06 +0200 From: Baptiste Daroussin To: tech-lists Cc: freebsd-pkg@freebsd.org Subject: Re: removing a pkg from pkg database without deleting the pkg itself Message-ID: <20220407065406.54uggzwqszzmzfx3@aniel.nours.eu> References: <20220405071716.vdvxrwyqdjltvjtm@aniel.nours.eu> List-Id: Binary package management and package tools discussion List-Archive: https://lists.freebsd.org/archives/freebsd-pkg List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-pkg@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1649314448; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: in-reply-to:in-reply-to:references:references; bh=TDQ6osUiAVsRJgGByAVUvlyHTvqCOuuc8vXr2K8v3o8=; b=Ze+neMBPZ/E8RVfs0sUgyK4BlP8nmH0wHHAyMYvaNRAe0uPtb0+8vXw4jbBkJVQdl5oQB0 O5Q7X/5KAePCnRcHVo2G0L8+sArwym3x7ZOXo4/1MzbEbMq8UZUgwnPKROTN5Q/VvtkDdc T3v2LycWSJKbpwAlL4XlCrOLZvRvXGI4lufhfqVngrug8UwQYRC/G0q1wiVsHEUvSQkkcI FtUQKV4IVBCeeuqDx5xJNPA/KZVqM3FY9/mqIq5bO7P7BHBwLW4XlZizRLNLxp5XsZnytF UaCaa2U2hswIgbUewQp8jLXS4R7fZzvs1k5RXrGnd4CXHRU3PbGSP6FF3v6LvA== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1649314448; a=rsa-sha256; cv=none; b=Ytqpv3jdiwbxUlln3rZaqZDv16BNybvRtlJm86iXPEO3HxwnxVQ2/se5/AV1KMt7a75L2U QvtuQpCI4ssdsZRb0WCrqYQFeu7sfYNXWQkKwAPzBWQgfrgdun1XyUoQYLaKqwd2a32jgA PcdYYIPnO9oo360DdbA3e4oK330O9aq/KpQjH99nydE4+elcacrUuJUGa1Ztcvm441MOQB ua/k+fCK8Z/44BlPsCq5JaNK+QdTt41eJswY61IGtuyjs0SUdJ6jlXjfm7M52wvhwC5EN0 QVOd6i1iDH38eGxfZYssjlS/O5Bo/ufckcWoeW9pxpO0a3pGzIv7ybz3p0vqqw== ARC-Authentication-Results: i=1; mx1.freebsd.org; none X-ThisMailContainsUnwantedMimeParts: N On Thu, Apr 07, 2022 at 12:31:04AM +0100, tech-lists wrote: > On Tue, Apr 05, 2022 at 09:17:16AM +0200, Baptiste Daroussin wrote: > > > > pkg shell "delete from packages where name='youpackagename'" > > > > This will do the trick > > Unfortunately that didn't work. I tried the following: > > pkg shell "delete from packages where name='nextcloud-php80-23.0.3'" > > pkg shell "delete from packages where name='www/nextcloud'" > > No errors, but pkg info -xo still showed: > > # pkg info -xo nextc > nextcloud-php80-23.0.3 www/nextcloud > > next, tried the pkg sqlite shell: > > sqlite> delete from packages where name="nextcloud-php80-23.0.3"; > sqlite> delete from packages where name="www/nextcloud"; > sqlite> .quit delete from packages where name="nextcloud-php80" > > same result. > -- > J.