Re: Simplify calls of pg_class_aclcheck when multiple modes are used

Поиск
Список
Период
Сортировка
От Fabrízio de Royes Mello
Тема Re: Simplify calls of pg_class_aclcheck when multiple modes are used
Дата
Msg-id CAFcNs+pqkmmA5FjHUGzB5bdH7Lg-MWVuHwpex0_rvJi-Ro+57w@mail.gmail.com
обсуждение исходный текст
Ответ на Simplify calls of pg_class_aclcheck when multiple modes are used  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-hackers
<div dir="ltr"><div class="gmail_extra">On Wed, Aug 27, 2014 at 9:02 AM, Michael Paquier <<a
href="mailto:michael.paquier@gmail.com">michael.paquier@gmail.com</a>>wrote:<br />><br />> Hi all,<br
/>><br/>> In a couple of code paths we do the following to check permissions on an object:<br />> if
(pg_class_aclcheck(relid,userid, ACL_USAGE) != ACLCHECK_OK &&<br />>     pg_class_aclcheck(relid, userid,
ACL_UPDATE)!= ACLCHECK_OK)<br />>     ereport(ERROR, blah);<br />><br />> Wouldn't it be better to simplify
thatwith a single call of pg_class_aclcheck, gathering together the modes that need to be checked? In the case above,
thecall to pg_class_aclcheck would become like that:<br />> if (pg_class_aclcheck(relid, userid,<br />>        
 ACL_USAGE| ACL_UPDATE) != ACLCHECK_OK)<br />>     ereport(ERROR, blah);<br />><br />> That's not a critical
thing,but it would save some cycles. Patch is attached.<br />><br /><br /></div><div class="gmail_extra">I did a
littlereview:<br /></div><div class="gmail_extra">- applied to master without errors<br /></div><div
class="gmail_extra">-no compiler warnings<br /></div><div class="gmail_extra">- no regressions<br /></div><div
class="gmail_extra"><br/></div><div class="gmail_extra">It's a minor change and as Michael already said would save some
cycles.<br /><br /></div><div class="gmail_extra">Marked as "Ready for commiter".<br /></div><div
class="gmail_extra"><br/></div><div class="gmail_extra">Regards,<br /></div><div class="gmail_extra"><br />--<br
/>Fabríziode Royes Mello<br />Consultoria/Coaching PostgreSQL<br />>> Timbira: <a
href="http://www.timbira.com.br">http://www.timbira.com.br</a><br/>>> Blog: <a
href="http://fabriziomello.github.io">http://fabriziomello.github.io</a><br/>>> Linkedin: <a
href="http://br.linkedin.com/in/fabriziomello">http://br.linkedin.com/in/fabriziomello</a><br/>>> Twitter: <a
href="http://twitter.com/fabriziomello">http://twitter.com/fabriziomello</a><br/>>> Github: <a
href="http://github.com/fabriziomello">http://github.com/fabriziomello</a></div></div>

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Fabrízio de Royes Mello
Дата:
Сообщение: Re: CREATE IF NOT EXISTS INDEX
Следующее
От: Robert Haas
Дата:
Сообщение: copy.c handling for RLS is insecure