pkg set -n will try to update the database even if the confirmation prompt was answered with "n". Expected behaviour is to abort. Test was run on PC-BSD 10.1. [nde@pcbsd] /usr/local/etc# pkg set -n linux-c6-flashplugin:vim pcbsd-base Change name from linux-c6-flashplugin to vim for linux-c6-flashplugin-11.2r202.457? [y/N]: n pkg: sqlite error while executing UPDATE deps SET name = ?1, version=(SELECT version FROM packages WHERE name = ?1) WHERE package_id = ?2 AND name = ?3 in file pkgdb.c:2551: UNIQUE constraint failed: deps.name, deps.version, deps.package_id [nde@pcbsd] /usr/local/etc# pkg set -n linux-c6-flashplugin:vim pcbsd-base Change name from linux-c6-flashplugin to vim for linux-c6-flashplugin-11.2r202.457? [y/N]: y pkg: sqlite error while executing UPDATE packages SET name=?1 WHERE id=?2 in file pkgdb.c:2551: UNIQUE constraint failed: packages.name (I was trying to remove the dependency for flash in pcbsd-base. It fails because vim is already a dependency. Therefore the sqlite error is justified.)
This has been fixed.