On 04/09/2017 03:01 PM, Joe Conway wrote: > On 04/09/2017 02:49 PM, Andres Freund wrote: >> On 2017-04-09 14:28:48 -0700, Joe Conway wrote: >>> Interesting -- rhino is now failing. I tested a minute ago manually on >>> the same buildfarm animal and it passed. I'm on it. >> >> The module for segpsql really needs to be improved so it logs >> regression.diffs - iirc several other modules do. > > Sure, but for another day I think. > > I turned on the buildfarm "keep" setting and looked at the diffs. The > issue is that in there are a few places that do "SELECT ... FROM > pg_seclabels ... ORDER BY ..." and when manually testing I get default > database encoding "UTF8" but with the buildfarm I get "SQL_ASCII", hence > a different sorting.
Looks like adding COLLATE "C" in the ORDER BY clauses does the trick. Is that the preferred method for this kind of issue? Joe -- Crunchy Data - http://crunchydata.com PostgreSQL Support for Secure Enterprises Consulting, Training, & Open Source Development
signature.asc
Description: OpenPGP digital signature