Re: Deprecating RULES - Mailing list pgsql-hackers

From Любен Каравелов
Subject Re: Deprecating RULES
Date
Msg-id 0838daae75992f1b4f0d320476ea9bdf.mailbg@beta.mail.bg
Whole thread Raw
In response to Re: Deprecating RULES  (Robert Haas <robertmhaas@gmail.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: embedded list
Next
From: Simon Riggs
Date:
Subject: Re: Skip checkpoint on promoting from streaming replication