Re: Missing rows with index scan when collation is not "C" (PostgreSQL 9.5)

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	Robert Haas <robertmhaas(at)gmail(dot)com>
Cc:	Peter Geoghegan <pg(at)heroku(dot)com>, Marc-Olaf Jaschke <marc-olaf(dot)jaschke(at)s24(dot)com>, Postgres-Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject:	Re: Missing rows with index scan when collation is not "C" (PostgreSQL 9.5)
Date:	2016-03-23 00:51:38
Message-ID:	23483.1458694298@sss.pgh.pa.us
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2016-03-21 20:40:37 from Marc-Olaf Jaschke <marc-olaf(dot)jaschke(at)s24(dot)com>  2016-03-22 00:03:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2016-03-22 00:26:25 from Robert Haas <robertmhaas(at)gmail(dot)com>    2016-03-22 00:27:13 from Peter Geoghegan <pg(at)heroku(dot)com>    2016-03-22 00:44:41 from Peter Geoghegan <pg(at)heroku(dot)com>     2016-03-22 01:15:42 from Peter Geoghegan <pg(at)heroku(dot)com>      2016-03-22 02:54:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>       2016-03-22 04:04:18 from Peter Geoghegan <pg(at)heroku(dot)com>        2016-03-22 21:09:52 from Peter Geoghegan <pg(at)heroku(dot)com>         2016-03-22 22:06:37 from Robert Haas <robertmhaas(at)gmail(dot)com>          2016-03-22 23:19:44 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎           2016-03-22 23:48:31 from Robert Haas <robertmhaas(at)gmail(dot)com>            2016-03-23 00:05:19 from Robert Haas <robertmhaas(at)gmail(dot)com> 📎             2016-03-23 00:51:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>              2016-03-23 00:57:05 from Robert Haas <robertmhaas(at)gmail(dot)com>               2016-03-23 01:02:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>           2016-03-22 23:51:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>            2016-03-22 23:52:46 from Robert Haas <robertmhaas(at)gmail(dot)com>             2016-03-22 23:59:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>            2016-03-22 23:58:29 from Peter Geoghegan <pg(at)heroku(dot)com>           2016-03-23 01:15:09 from Stephen Frost <sfrost(at)snowman(dot)net>           2016-03-23 01:18:37 from Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com> 📎            2016-03-23 01:42:53 from Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>           2016-03-23 01:20:00 from Stephen Frost <sfrost(at)snowman(dot)net>           2016-03-23 01:30:11 from Stephen Frost <sfrost(at)snowman(dot)net>           2016-03-23 01:45:44 from Stephen Frost <sfrost(at)snowman(dot)net>           2016-03-23 01:49:56 from Stephen Frost <sfrost(at)snowman(dot)net>           2016-03-23 02:44:45 from Noah Misch <noah(at)leadboat(dot)com> 📎            2016-03-23 14:47:07 from Robert Haas <robertmhaas(at)gmail(dot)com>             2016-03-23 15:43:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎              2016-03-23 16:13:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>               2016-03-23 16:19:02 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                2016-03-23 17:22:12 from Robert Haas <robertmhaas(at)gmail(dot)com>               2016-03-23 17:23:45 from Robert Haas <robertmhaas(at)gmail(dot)com>                2016-03-23 17:46:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                 2016-03-23 17:52:14 from Peter Geoghegan <pg(at)heroku(dot)com>                  2016-03-23 17:56:32 from Magnus Hagander <magnus(at)hagander(dot)net>                   2016-03-23 17:58:41 from Peter Geoghegan <pg(at)heroku(dot)com>                    2016-03-23 18:00:07 from Peter Geoghegan <pg(at)heroku(dot)com>                    2016-03-23 18:04:44 from Magnus Hagander <magnus(at)hagander(dot)net>                     2016-03-23 18:06:47 from Peter Geoghegan <pg(at)heroku(dot)com>                      2016-03-23 18:09:53 from Magnus Hagander <magnus(at)hagander(dot)net>                       2016-03-23 18:14:35 from Peter Geoghegan <pg(at)heroku(dot)com>                        2016-03-24 13:04:22 from Magnus Hagander <magnus(at)hagander(dot)net>                         2016-03-24 14:14:06 from Robert Haas <robertmhaas(at)gmail(dot)com>                          2016-03-24 19:10:42 from Peter Geoghegan <pg(at)heroku(dot)com>                           2016-03-24 19:20:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                            2016-03-24 19:29:40 from Peter Geoghegan <pg(at)heroku(dot)com>                             2016-03-24 19:47:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                         2016-03-24 14:17:27 from Bernd Helmle <mailings(at)oopsware(dot)de>                         2016-03-24 20:28:08 from Peter Geoghegan <pg(at)heroku(dot)com>                      2016-03-23 18:32:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                       2016-03-23 18:40:22 from Peter Geoghegan <pg(at)heroku(dot)com>                       2016-03-23 18:56:53 from Robert Haas <robertmhaas(at)gmail(dot)com> 📎                        2016-03-23 19:01:36 from Peter Geoghegan <pg(at)heroku(dot)com>                         2016-03-23 19:04:37 from Robert Haas <robertmhaas(at)gmail(dot)com>                          2016-03-23 19:07:27 from Peter Geoghegan <pg(at)heroku(dot)com>                        2016-03-23 19:20:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                         2016-03-23 20:07:09 from Robert Haas <robertmhaas(at)gmail(dot)com>                          2016-03-30 14:00:36 from Marc-Olaf Jaschke <marc-olaf(dot)jaschke(at)s24(dot)com>                    2016-03-23 18:13:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                 2016-08-23 00:36:31 from Peter Geoghegan <pg(at)heroku(dot)com>                  2016-08-23 13:26:58 from Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>                2016-03-23 18:02:32 from Peter Geoghegan <pg(at)heroku(dot)com>           2016-03-23 10:32:06 from Bernd Helmle <mailings(at)oopsware(dot)de> 📎          2016-03-23 02:33:49 from Peter Geoghegan <pg(at)heroku(dot)com>           2016-03-23 02:41:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>            2016-03-23 21:34:33 from Peter Geoghegan <pg(at)heroku(dot)com>             2016-03-23 21:51:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>              2016-03-23 22:08:05 from Peter Geoghegan <pg(at)heroku(dot)com>         2016-03-22 23:26:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>          2016-03-22 23:27:09 from Peter Geoghegan <pg(at)heroku(dot)com>  2016-03-22 00:34:17 from Peter Geoghegan <pg(at)heroku(dot)com>   2016-03-22 04:10:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>    2016-03-22 05:16:34 from Peter Geoghegan <pg(at)heroku(dot)com>     2016-03-22 07:53:31 from Peter Geoghegan <pg(at)heroku(dot)com>  2016-03-22 01:09:53 from Peter Geoghegan <pg(at)heroku(dot)com>
Lists:	pgsql-bugs pgsql-hackers

In response to

• Re: Missing rows with index scan when collation is not "C" (PostgreSQL 9.5) at 2016-03-23 00:05:19 from Robert Haas

Responses

• Re: Missing rows with index scan when collation is not "C" (PostgreSQL 9.5) at 2016-03-23 00:57:05 from Robert Haas

Browse pgsql-bugs by date

	From	Date	Subject
Next Message	Robert Haas	2016-03-23 00:57:05	Re: Missing rows with index scan when collation is not "C" (PostgreSQL 9.5)
Previous Message	Robert Haas	2016-03-23 00:05:19	Re: Missing rows with index scan when collation is not "C" (PostgreSQL 9.5)

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	David G. Johnston	2016-03-23 00:52:23	Re: problem with precendence order in JSONB merge operator
Previous Message	Craig Ringer	2016-03-23 00:51:12	Re: Timeline following for logical slots