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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jiří Fejfar <jurafejfar(at)gmail(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails
Date: 2020-08-19 05:53:07
Message-ID: 1375263.1597816387@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

=?UTF-8?B?SmnFmcOtIEZlamZhcg==?= <jurafejfar(at)gmail(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jiří Fejfar 2020-08-19 06:08:42 Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails
Previous Message Jiří Fejfar 2020-08-19 05:39:36 Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails

Browse pgsql-hackers by date

  From Date Subject
Next Message Andy Fan 2020-08-19 05:55:16 Re: Pulling up direct-correlated ANY_SUBLINK
Previous Message Drouvot, Bertrand 2020-08-19 05:48:24 Re: Display individual query in pg_stat_activity