pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Daniel Westermann (DWE) <daniel.westermann@dbi-services.com>
Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: Re: Wrong results with postgres_fdw and merge anti join from RHEL 7.9 to RHEL 8.7
Date: Wed, 05 Apr 2023 16:07:28 -0400
Message-ID: <2060816.1680725248@sss.pgh.pa.us> (raw)
In-Reply-To: <GV0P278MB041930B2E5FE2DFEC77FE36FD2909@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
References: <GV0P278MB0419C826AF173592DA648C88D2909@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
	<2017352.1680720065@sss.pgh.pa.us>
	<GV0P278MB04193FBC28A1744C6945B81ED2909@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
	<2020213.1680721496@sss.pgh.pa.us>
	<GV0P278MB041930B2E5FE2DFEC77FE36FD2909@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>

"Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com> writes:
>> The sample data you showed seemed to only involve numeric-ish strings,
>> which would be highly unlikely to change sort order across locale
>> updates.  But maybe there are weirder entries elsewhere in the column?

> I can probably provide a dump, but I've to ask. Would that help?

I wasn't volunteering to check the data for you ;-), just suggesting
that you might find it interesting to do so yourself.

			regards, tom lane





view thread (9+ messages)  latest in thread

Message-ID: <2060816.1680725248@sss.pgh.pa.us>
Permalink:  ../2060816.1680725248@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/2060816.1680725248@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: tgl@sss.pgh.pa.us, daniel.westermann@dbi-services.com, pgsql-bugs@lists.postgresql.org
  Subject: Re: Wrong results with postgres_fdw and merge anti join from RHEL 7.9 to RHEL 8.7
  In-Reply-To: <2060816.1680725248@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox