Re: ExecRTCheckPerms() and many prunable partitions
От
Alvaro Herrera
Тема
Re: ExecRTCheckPerms() and many prunable partitions
Дата
Msg-id
20221207104259.zp325sj7dah7za33@alvherre.pgsql
Ответ на
Re: ExecRTCheckPerms() and many prunable partitions (Alvaro Herrera)
Список
Дерево обсуждения
ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Tom Lane <tgl@sss.pgh.pa.us>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Julien Rouhaud <rjuju123@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Zhihong Yu <zyu@yugabyte.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: ExecRTCheckPerms() and many prunable partitions David Rowley <dgrowleyml@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Greg Stark <stark@mit.edu>
Re: ExecRTCheckPerms() and many prunable partitions David Rowley <dgrowleyml@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Tom Lane <tgl@sss.pgh.pa.us>
Re: ExecRTCheckPerms() and many prunable partitions Tom Lane <tgl@sss.pgh.pa.us>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Tom Lane <tgl@sss.pgh.pa.us>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: ExecRTCheckPerms() and many prunable partitions Tom Lane <tgl@sss.pgh.pa.us>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Ian Lawrence Barwick <barwick@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: ExecRTCheckPerms() and many prunable partitions Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: ExecRTCheckPerms() and many prunable partitions Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: ExecRTCheckPerms() and many prunable partitions (checkAsUser) Justin Pryzby <pryzby@telsasoft.com>
Re: ExecRTCheckPerms() and many prunable partitions (checkAsUser) Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions (checkAsUser) Justin Pryzby <pryzby@telsasoft.com>
Re: ExecRTCheckPerms() and many prunable partitions (checkAsUser) Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: ExecRTCheckPerms() and many prunable partitions (checkAsUser) Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: ExecRTCheckPerms() and many prunable partitions (checkAsUser) Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions (checkAsUser) Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: ExecRTCheckPerms() and many prunable partitions (checkAsUser) Tom Lane <tgl@sss.pgh.pa.us>
Re: ExecRTCheckPerms() and many prunable partitions (checkAsUser) Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions (checkAsUser) Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions (checkAsUser) Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions (checkAsUser) Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions (checkAsUser) Justin Pryzby <pryzby@telsasoft.com>
Re: ExecRTCheckPerms() and many prunable partitions (checkAsUser) Justin Pryzby <pryzby@telsasoft.com>
Re: ExecRTCheckPerms() and many prunable partitions (checkAsUser) Tom Lane <tgl@sss.pgh.pa.us>
Re: ExecRTCheckPerms() and many prunable partitions (checkAsUser) Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: ExecRTCheckPerms() and many prunable partitions (checkAsUser) Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions (checkAsUser) Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: ExecRTCheckPerms() and many prunable partitions (sqlsmith) Justin Pryzby <pryzby@telsasoft.com>
Re: ExecRTCheckPerms() and many prunable partitions (sqlsmith) Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions (sqlsmith) Tom Lane <tgl@sss.pgh.pa.us>
Re: ExecRTCheckPerms() and many prunable partitions (sqlsmith) Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Andres Freund <andres@anarazel.de>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Zhihong Yu <zyu@yugabyte.com>
Re: ExecRTCheckPerms() and many prunable partitions David Rowley <dgrowleyml@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions David Rowley <dgrowleyml@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions Amit Langote <amitlangote09@gmail.com>
Re: ExecRTCheckPerms() and many prunable partitions David Rowley <dgrowleyml@gmail.com>
On 2022-Dec-06, Alvaro Herrera wrote: > I have pushed this finally. > > I made two further changes: Actually, I made one further change that I forgot to mention -- I changed the API of CombineRangeTables once again; the committed patch has it this way: +/* + * CombineRangeTables + * Adds the RTEs of 'src_rtable' into 'dst_rtable' + * + * This also adds the RTEPermissionInfos of 'src_perminfos' (belonging to the + * RTEs in 'src_rtable') into *dst_perminfos and also updates perminfoindex of + * the RTEs in 'src_rtable' to now point to the perminfos' indexes in + * *dst_perminfos. + * + * Note that this changes both 'dst_rtable' and 'dst_perminfo' destructively, + * so the caller should have better passed safe-to-modify copies. + */ +void +CombineRangeTables(List **dst_rtable, List **dst_perminfos, + List *src_rtable, List *src_perminfos) The original one had the target rangetable first, then the source RT+perminfos, and the target perminfos at the end. This seemed inconsistent and potentially confusing. I also changed the argument names (from using numbers to "dst/src" monikers) and removed the behavior of returning the list: ISTM it did turn out to be a bad idea after all. -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/
В списке pgsql-hackers по дате отправления
От: Hamid Akhtar
Дата:
От: Amit Kapila
Дата: