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:	pgsql-hackers(at)lists(dot)postgresql(dot)org
Cc:	Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, jurafejfar(at)gmail(dot)com
Subject:	Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails
Date:	2021-02-07 07:55:50
Message-ID:	422379.1612684550@sss.pgh.pa.us
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2020-08-17 12:02:41 from PG Bug reporting form <noreply(at)postgresql(dot)org>  2020-08-17 15:26:48 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2020-08-17 22:37:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎    2020-08-18 20:09:44 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎     2021-01-28 12:31:46 from Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>      2021-01-28 16:44:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>       2021-02-07 07:55:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎        2021-03-03 08:41:49 from Neil Chen <carpenter(dot)nail(dot)cz(at)gmail(dot)com>         2021-07-13 11:07:41 from Ibrar Ahmed <ibrar(dot)ahmad(at)gmail(dot)com>          2021-07-13 20:41:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎           2021-07-14 19:16:31 from Ibrar Ahmed <ibrar(dot)ahmad(at)gmail(dot)com>            2021-07-15 09:35:33 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>             2021-07-15 13:02:28 from Ibrar Ahmed <ibrar(dot)ahmad(at)gmail(dot)com>             2021-09-01 20:42:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎              2021-09-02 02:56:25 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>              2021-09-09 15:45:32 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> 📎               2021-09-09 16:00:21 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                2021-09-10 11:42:27 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>                 2021-09-24 08:36:06 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>                  2021-09-24 19:11:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                   2021-09-25 13:55:29 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>                    2021-09-25 13:59:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                     2021-09-26 08:56:57 from Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>                     2021-10-01 19:37:31 from Jeremy Schneider <schnjere(at)amazon(dot)com>                    2021-09-25 14:59:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2020-08-19 05:39:36 from Jiří Fejfar <jurafejfar(at)gmail(dot)com>    2020-08-19 05:53:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2020-08-19 06:08:42 from Jiří Fejfar <jurafejfar(at)gmail(dot)com>
Lists:	pgsql-bugs pgsql-hackers

Attachment	Content-Type	Size
fix-postgres-fdw-collation-handling-2.patch	text/x-diff	37.6 KB

In response to

• Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails at 2021-01-28 16:44:09 from Tom Lane

Responses

• Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails at 2021-03-03 08:41:49 from Neil Chen

Browse pgsql-bugs by date

	From	Date	Subject
Next Message	PG Bug reporting form	2021-02-07 20:25:09	BUG #16857: Postgres Installer fails when user inserts slash / in password field
Previous Message	Piotr Włodarczyk	2021-02-07 01:28:45	Re: SV: Problem with pg_notify / listen

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Joel Jacobson	2021-02-07 09:54:51	jsonb_array_elements_recursive()
Previous Message	Julien Rouhaud	2021-02-07 07:20:17	Re: REINDEX backend filtering