Re: ExecRTCheckPerms() and many prunable partitions

Поиск
Список
Период
Сортировка
Искать
От
Alvaro Herrera
Тема
Re: ExecRTCheckPerms() and many prunable partitions
Дата
Msg-id
20221207104259.zp325sj7dah7za33@alvherre.pgsql
Ответ на
Список
Дерево обсуждения
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
Дата:
FAQ