On 04/09/2017 04:14 PM, Tom Lane wrote: > Joe Conway <m...@joeconway.com> writes: >>> 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? > > Yeah, that's pretty much the standard fix nowadays.
Good to hear, thanks -- rhino is back to green. Joe -- Crunchy Data - http://crunchydata.com PostgreSQL Support for Secure Enterprises Consulting, Training, & Open Source Development
signature.asc
Description: OpenPGP digital signature