Horton

Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jiří Fejfar <jurafejfar@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Date: 2020-08-19T05:53:07Z
Lists: pgsql-bugs, pgsql-hackers 
=?UTF-8?B?SmnFmcOtIEZlamZhcg==?= <jurafejfar@gmail.com> writes:
> I am just wondering: if it is bug in IMPORT FOREIGN SCHEMA, how it is 
> possible the bug is not present [1] when provided psql script [2] is run 
> on Alpine Linux?

[ shrug ]  Could easy be that Alpine distributes dumbed-down locale
definitions in which the sort order isn't actually any different
between those two locales.  Did you check what the sort order of
your test data looks like in each case?

			regards, tom lane

Commits

  1. Doc: extend warnings about collation-mismatch hazards in postgres_fdw.

  2. Add support for asynchronous execution.

  3. Suppress unnecessary RelabelType nodes in yet more cases.