Re: Weird "could not determine which collation to use for string comparison" with LEAST/GREATEST on PG11 procedure
Peter Eisentraut <[email protected]> Thu, 7 Feb 2019 08:29:47 +0100
| Newsgroups | gmane.comp.db.postgresql.bugs,gmane.comp.db.postgresql.sql |
|---|---|
| Organization | 2ndQuadrant |
| Message-ID | <[email protected]> |
On 05/02/2019 15:46, Tom Lane wrote: > Peter Eisentraut <[email protected]> writes: >> On 21/11/2018 19:19, Tom Lane wrote: >>> Yeah, same here. I think somebody forgot to run assign_expr_collations() >>> on CALL arguments. > >> This appears to fix it. > > I think this should be fine as a band-aid patch. As I mentioned > previously, I'm not really happy with our generally-unprincipled > approach to where collation assignment is called from ... but a > bug-fix patch should probably not be tasked with making that > better. Especially not with less than a week till 11.2. committed -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services