Yeah, when a column of the underlying table renamed, this re-executing must be failed...
2009-12-19 suzhiyang 发件人: Robert Haas 发送时间: 2009-12-19 11:17:44 收件人: suzhiyang 抄送: pgsql-hackers 主题: Re: [HACKERS] About "Allow VIEW/RULE recompilation when theunderlying tables change" On Fri, Dec 18, 2009 at 9:58 PM, suzhiyang <suzhiy...@gmail.com> wrote: > I'm doing the Todo List's "Allow VIEW/RULE recompilation when the underlying > tables change ". I've a very simple idea that I save the "create view" > query_string in systable. When I found that I select from a view, I drop the > view and recreate the view by execute the source query_string. Then go on > execute this "select from a view" and will get the right answer. My problem > is that how could I get the orginal query which user typed to postgres? > Er, maybe drop and recreate the view is an ugly idea...Is there any better > methods to do recompilation? I am not sure what this TODO item is supposed to refer to, but saving the query string and re-executing it is clearly not acceptable. What if a column or table or function referenced in the query has been renamed since the view/rule was created? ...Robert