Re: Patch: Global Unique Index
От
Vik Fearing
Тема
Re: Patch: Global Unique Index
Дата
Msg-id
922afef1-430c-e929-2589-ec3190bb11d7@postgresfriends.org
Ответ на
Re: Patch: Global Unique Index (Laurenz Albe)
Список
Дерево обсуждения
Patch: Global Unique Index Cary Huang <cary.huang@highgo.ca>
Re:Patch: Global Unique Index Sergei Kornilov <sk@zsrv.org>
Re: Patch: Global Unique Index Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch: Global Unique Index Thomas Kellerer <shammat@gmx.net>
Re: Patch: Global Unique Index Pavel Stehule <pavel.stehule@gmail.com>
Re: Patch: Global Unique Index Thomas Kellerer <shammat@gmx.net>
Re: Patch: Global Unique Index Cary Huang <cary.huang@highgo.ca>
Re: Patch: Global Unique Index Vik Fearing <vik@postgresfriends.org>
Re: Patch: Global Unique Index Laurenz Albe <laurenz.albe@cybertec.at>
Re: Patch: Global Unique Index Vik Fearing <vik@postgresfriends.org>
Re: Patch: Global Unique Index Laurenz Albe <laurenz.albe@cybertec.at>
Re: Patch: Global Unique Index Pavel Stehule <pavel.stehule@gmail.com>
Re: Patch: Global Unique Index Pavel Stehule <pavel.stehule@gmail.com>
Re: Patch: Global Unique Index Ilya Anfimov <ilan@tzirechnoy.com>
Re: Patch: Global Unique Index Dilip Kumar <dilipbalaut@gmail.com>
Re: Patch: Global Unique Index Justin Pryzby <pryzby@telsasoft.com>
Re: Patch: Global Unique Index Dilip Kumar <dilipbalaut@gmail.com>
Re: Patch: Global Unique Index Dilip Kumar <dilipbalaut@gmail.com>
Re: Patch: Global Unique Index Simon Riggs <simon.riggs@enterprisedb.com>
Re: Patch: Global Unique Index Cary Huang <cary.huang@highgo.ca>
Re: Patch: Global Unique Index Bruce Momjian <bruce@momjian.us>
Re: Patch: Global Unique Index David Zhang <david.zhang@highgo.ca>
Re: Patch: Global Unique Index Greg Stark <stark@mit.edu>
Re: Patch: Global Unique Index Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch: Global Unique Index David Zhang <david.zhang@highgo.ca>
Re: Patch: Global Unique Index Bruce Momjian <bruce@momjian.us>
Re: Patch: Global Unique Index Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch: Global Unique Index Cary Huang <cary.huang@highgo.ca>
Re: Patch: Global Unique Index David Zhang <david.zhang@highgo.ca>
Re: Patch: Global Unique Index Nikita Malakhov <hukutoc@gmail.com>
Re: Patch: Global Unique Index David Zhang <david.zhang@highgo.ca>
Re: Patch: Global Unique Index Greg Stark <stark@mit.edu>
Re: Patch: Global Unique Index Cary Huang <cary.huang@highgo.ca>
Re: Patch: Global Unique Index Nikita Malakhov <hukutoc@gmail.com>
Re: Patch: Global Unique Index Bruce Momjian <bruce@momjian.us>
Re: Patch: Global Unique Index Bruce Momjian <bruce@momjian.us>
On 11/29/22 17:29, Laurenz Albe wrote: > On Tue, 2022-11-29 at 13:58 +0100, Vik Fearing wrote: >> I disagree. A user does not need to know that a table is partitionned, >> and if the user wants a unique constraint on the table then making them >> type an extra word to get it is just annoying. > > Hmm. But if I created a primary key without thinking too hard about it, > only to discover later that dropping old partitions has become a problem, > I would not be too happy either. I have not looked at this patch, but my understanding of its design is the "global" part of the index just makes sure to check a unique index on each partition. I don't see from that how dropping old partitions would be a problem. -- Vik Fearing
В списке pgsql-hackers по дате отправления
