Re: going through upgrade: could not determine which collation to use
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.
snapshotdb=> \d binpkg
Table "public.binpkg"
Column | Type | Modifiers
-----------+------------------------+------------------------------------------------------------
binpkg_id | integer | not null default nextval('binpkg_binpkg_id_seq'::regclass)
name | character varying(128) | not null
version | debversion | not null
srcpkg_id | integer | not null
Indexes:
"binpkg_pkey" PRIMARY KEY, btree (binpkg_id)
"binpkg_idx_name" btree (name)
Foreign-key constraints:
"binpkg_srcpkg_id_fkey" FOREIGN KEY (srcpkg_id) REFERENCES srcpkg(srcpkg_id)
Referenced by:
TABLE "file_binpkg_mapping" CONSTRAINT "file_binpkg_mapping_binpkg_id_fkey" FOREIGN KEY (binpkg_id) REFERENCES binpkg(binpkg_id)
and apparently I was missing postgresql-9.4-debversion postgresql-plperl-9.4
for this version of the postgres -- installed, and restarted but unfortunately
didn't resolve the issue yet.
any recollection on possible ingredients to make sorting by debversion
work?
--
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
Reply to: