On Feb 20, 2012, at 15:06, Blair Zajac wrote: > # /usr/bin/sqlite3 registry.db > SQLite version 3.7.7 2011-06-25 16:35:41 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> select id from ports where name = 'mercurial'; > Error: no such collation sequence: VERSION
You can't just use vanilla sqlite to access MacPorts' database because it has a custom collation. Here's how you would work around that: http://lists.macosforge.org/pipermail/macports-users/2010-July/020923.html _______________________________________________ macports-dev mailing list [email protected] http://lists.macosforge.org/mailman/listinfo.cgi/macports-dev
