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. regards, tom lane -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers