Re: SQL:2011 application time
От
Peter Eisentraut
Тема
Re: SQL:2011 application time
Дата
Msg-id
6dc196d4-8853-49d7-8dd3-e391058451c1@eisentraut.org
Список
Дерево обсуждения
SQL:2011 application time Paul A Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Paul A Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Paul A Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Jaime Casanova <jcasanov@systemguards.com.ec>
Re: SQL:2011 application time Paul A Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Jaime Casanova <jcasanov@systemguards.com.ec>
Re: SQL:2011 application time Paul A Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Corey Huinker <corey.huinker@gmail.com>
Re: SQL:2011 application time Paul A Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Corey Huinker <corey.huinker@gmail.com>
Re: SQL:2011 application time Paul A Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Paul A Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Julien Rouhaud <rjuju123@gmail.com>
Re: SQL:2011 application time Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: SQL:2011 application time Paul A Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: SQL:2011 application time Daniel Gustafsson <daniel@yesql.se>
Re: SQL:2011 application time Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: SQL:2011 application time Daniel Gustafsson <daniel@yesql.se>
Re: SQL:2011 application time Paul A Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Peter Eisentraut <peter@eisentraut.org>
Re: SQL:2011 application time Vik Fearing <vik@postgresfriends.org>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Vik Fearing <vik@postgresfriends.org>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time Paul A Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Peter Eisentraut <peter@eisentraut.org>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Vik Fearing <vik@postgresfriends.org>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time Paul A Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Peter Eisentraut <peter@eisentraut.org>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Peter Eisentraut <peter@eisentraut.org>
Re: SQL:2011 application time Peter Eisentraut <peter@eisentraut.org>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Peter Eisentraut <peter@eisentraut.org>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time Peter Eisentraut <peter@eisentraut.org>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Peter Eisentraut <peter@eisentraut.org>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Peter Eisentraut <peter@eisentraut.org>
Re: SQL:2011 application time Paul A Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Peter Eisentraut <peter@eisentraut.org>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time Paul A Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time Peter Eisentraut <peter@eisentraut.org>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Peter Eisentraut <peter@eisentraut.org>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Peter Eisentraut <peter@eisentraut.org>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Peter Eisentraut <peter@eisentraut.org>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Peter Eisentraut <peter@eisentraut.org>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time Michael Paquier <michael@paquier.xyz>
Re: SQL:2011 application time Peter Eisentraut <peter@eisentraut.org>
Re: SQL:2011 application time Peter Eisentraut <peter@eisentraut.org>
Re: SQL:2011 application time Jeff Davis <pgsql@j-davis.com>
Re: SQL:2011 application time Robert Haas <robertmhaas@gmail.com>
Re: SQL:2011 application time Isaac Morland <isaac.morland@gmail.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Robert Haas <robertmhaas@gmail.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Robert Haas <robertmhaas@gmail.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Peter Eisentraut <peter@eisentraut.org>
Re: SQL:2011 application time Paul A Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Peter Eisentraut <peter@eisentraut.org>
Re: SQL:2011 application time Peter Eisentraut <peter@eisentraut.org>
Re: SQL:2011 application time Paul A Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Peter Eisentraut <peter@eisentraut.org>
Re: SQL:2011 application time Tom Lane <tgl@sss.pgh.pa.us>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time Jeff Davis <pgsql@j-davis.com>
Re: SQL:2011 application time Robert Haas <robertmhaas@gmail.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Robert Haas <robertmhaas@gmail.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Peter Eisentraut <peter@eisentraut.org>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Peter Eisentraut <peter@eisentraut.org>
Re: SQL:2011 application time Matthias van de Meent <boekewurm+postgres@gmail.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Matthias van de Meent <boekewurm+postgres@gmail.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Matthias van de Meent <boekewurm+postgres@gmail.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time Peter Eisentraut <peter@eisentraut.org>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time Peter Smith <smithpb2250@gmail.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Vik Fearing <vik@postgresfriends.org>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time Paul Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time vignesh C <vignesh21@gmail.com>
Re: SQL:2011 application time Paul A Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time Corey Huinker <corey.huinker@gmail.com>
Re: SQL:2011 application time jian he <jian.universality@gmail.com>
Re: SQL:2011 application time Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: SQL:2011 application time Corey Huinker <corey.huinker@gmail.com>
Re: SQL:2011 application time Vik Fearing <vik@postgresfriends.org>
Re: SQL:2011 application time Paul A Jungwirth <pj@illuminatedcomputing.com>
Re: SQL:2011 application time Corey Huinker <corey.huinker@gmail.com>
Re: SQL:2011 application time Zhihong Yu <zyu@yugabyte.com>
I have committed the documentation patches v43-0001-Add-WITHOUT-OVERLAPS-and-PERIOD-to-ALTER-TABLE-r.patch v43-0002-Update-conexclop-docs-for-WITHOUT-OVERLAPS.patch For the logical replication fixes v43-0003-Fix-logical-replication-for-temporal-tables.patch can you summarize what the issues currently are? Is it currently broken, or just not working as well as it could? AFAICT, there might be two separate issues. One is that you can't use a temporal index as replica identity, because ALTER TABLE rejects it. The other is that a subscriber fails to make use of a replica identity index, because it uses the wrong strategy numbers. This conditional is really hard to understand: + /* + * The AM must support uniqueness, and the index must in fact be unique. + * If we have a WITHOUT OVERLAPS constraint (identified by uniqueness + + * exclusion), we can use that too. + */ + if ((!indexRel->rd_indam->amcanunique || + !indexRel->rd_index->indisunique) && + !(indexRel->rd_index->indisunique && indexRel->rd_index->indisexclusion)) Why can we have a indisunique index when the AM is not amcanunique? Are we using the fields wrong? - return get_equal_strategy_number_for_am(am); + /* For GiST indexes we need to ask the opclass what strategy number to use. */ + if (am == GIST_AM_OID) + return GistTranslateStratnum(opclass, RTEqualStrategyNumber); + else + return get_equal_strategy_number_for_am(am); This code should probably be pushed into get_equal_strategy_number_for_am(). That function already has a switch based on index AM OIDs. Also, there are other callers of get_equal_strategy_number_for_am(), which also might want to become aware of GiST support. For the new test file, remember to add it to src/test/subscription/meson.build. Also, maybe add a introductory comment in the test file to describe generally what it's trying to test.
В списке pgsql-hackers по дате отправления