Re: Deprecating RULES
От | Любен Каравелов |
---|---|
Тема | Re: Deprecating RULES |
Дата | |
Msg-id | 0838daae75992f1b4f0d320476ea9bdf.mailbg@beta.mail.bg обсуждение исходный текст |
Ответ на | Re: Deprecating RULES (Robert Haas <robertmhaas@gmail.com>) |
Список | pgsql-hackers |
<br /><blockquote style="border:none; padding:0; margin:0; background-color:#1010ff;" type="cite"><div style="margin-left:2px;background-color:white;"><div style="margin-left:13px;">Well, it'd be nice to be able to rewrite aquery referring to a table<br />to still refer to that same table, but you can't, because you get<br />infinite recursion.<br/></div></div></blockquote><p style="line-height: 16px; font-size: 13px; font-family: Tahoma,sans-serif; margin:16px 0px;"><p style="line-height: 16px; font-size: 13px; font-family: Tahoma,sans-serif; margin: 16px 0px;" valid="true">Ifthat was possible it would be quite easy to express any row/column level security policies with it.<p style="line-height:16px; font-size: 13px; font-family: Tahoma,sans-serif; margin: 16px 0px;" valid="true"><br /><blockquotestyle="border:none; padding:0; margin:0; background-color:#1010ff;" type="cite"><div style="margin-left:2px;background-color:white;"><div style="margin-left:13px;">If you could do that, it'd presumably be aWHOLE lot faster than<br />triggers. Because frankly, if triggers were infinitely fast, I don't<br />think we'd be havingthis conversation. But they're not. They're<br />slow; really slow, and while we may be able to improve that somewhat<br/>by some means, they're basically always going to be slow. Being able<br />to rewrite queries is inside the serveris useful, and rules are not a<br />very good solution to that problem, but right now they're the only<br />thing we'vegot.<br /></div></div></blockquote><p style="line-height: 16px; font-size: 13px; font-family: Tahoma,sans-serif; margin:16px 0px;"><p style="line-height: 16px; font-size: 13px; font-family: Tahoma,sans-serif; margin: 16px 0px;" valid="true">Moreoverthere are no triggers fired on selects. <br /><p style="line-height: 16px; font-size: 13px; font-family:Tahoma,sans-serif; margin: 16px 0px;"><p style="line-height: 16px; font-size: 13px; font-family: Tahoma,sans-serif;margin: 16px 0px;" valid="true">Best regards<br /><p style="font-family:Tahoma, sans-serif; font-size:13px;">--<br/><p style="line-height: 16px; font-size: 13px; font-family: Tahoma,sans-serif; margin: 16px 0px;"valid="true">Luben Karavelov
В списке pgsql-hackers по дате отправления: