Re: going through upgrade: could not determine which collation to use

[Yaroslav Halchenko <debian@onerussian.com>]

nevermind.

seems have resolved by redoing db migration after having installed
those debversions and plperl extensions

Cheers and thanks for the snapshots!

On Mon, 23 Oct 2017, Yaroslav Halchenko wrote:


> On Mon, 23 Oct 2017, Yaroslav Halchenko wrote:
> > 	>>  return super(DictCursor, self).execute(query, vars)

> > 	ProgrammingError: could not determine which collation to use for string comparison HINT: Use the COLLATE clause to set the collation explicitly

> So it is about sorting by debversion:

> snapshotdb=> SELECT * FROM binpkg WHERE binpkg.name='python-mvpa2' ORDER BY binpkg.version;
> ERROR:  could not determine which collation to use for string comparison
> HINT:  Use the COLLATE clause to set the collation explicitly.
-- 
Yaroslav O. Halchenko
Center for Open Neuroscience     http://centerforopenneuroscience.org
Dartmouth College, 419 Moore Hall, Hinman Box 6207, Hanover, NH 03755
Phone: +1 (603) 646-9834                       Fax: +1 (603) 646-1419
WWW:   http://www.linkedin.com/in/yarik