[HACKERS] Re: [HACKERS] Distinguish view and table problem

2009-12-19 Thread suzhiyang
y to solve another easier one to complete my work. These days I've learned a lot from your discussion and source code.:-) Thank you for your help! 2009-12-20 suzhiyang 发件人: Filip_Rembiałkowski 发送时间: 2009-12-20 08:33:31 收件人: Jaime Casanova 抄送: suzhiyang; Pgsql Hackers 主题: Re: [HACKE

[HACKERS] Re: Re: [HACKERS] About "Allow VIEW/RULE recompilation when theunderlying tables change"

2009-12-18 Thread suzhiyang
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&q

[HACKERS] About "Allow VIEW/RULE recompilation when the underlying tables change"

2009-12-18 Thread suzhiyang
te 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? Thank you! 2009-12-19 suzhiyang

[HACKERS] Distinguish view and table problem

2009-12-18 Thread suzhiyang
s that does postgres save the user's original query_string at anywhere(systable etc.)? If I want to save the sourceText in the systable, I could add a column to pg_class called query_string. How could I insert a line to pg_class or read a line from it? Thank you very much! 2009-12-18 suzhiyang