updating on views

Поиск
Список
Период
Сортировка
От XiaojingLi
Тема updating on views
Дата
Msg-id 20021127013628.B5B6C1D145CC3@sm204.163.com
обсуждение исходный текст
Ответы Re: updating on views  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-hackers
Hi!I'd like to bother you with something about updating views. At present, postgresql7.3 doesn't support update on
views.WhenI look up the source code, I see that view is implemented with rules. That is when a view is created, a
corresponding‘select' rule is created too. And I see the following code: 

#ifdef NOTYETRuleStmt   *replace_rule;RuleStmt   *append_rule;RuleStmt   *delete_rule;
#endif
.. ...

#ifdef NOTYETreplace_rule = FormViewReplaceRule(view, viewParse);append_rule = FormViewAppendRule(view,
viewParse);delete_rule= FormViewDeleteRule(view, viewParse); 
#endif
.. ...
In my eyes, it is not very difficult to realize view update with fill the above three functions。But I know the
developersof postgresql are very learned, now that they didn't realize view update, maybe it is very difficult. I am a
beginnerof postgresql, so with my limited knowlege, maybe  I can't realize the difficulity of doing such a thing. 
So I wonder if some of you would like to give me some advice about updating on views or why it is not realized、what's
thedifficulty of doing it? 
   Long for your reply.Thank you!

Best regards!



        

        Yours XiaojingLi
        qqjasmine@hotmail.com
          2002-11-23





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

Предыдущее
От: snpe
Дата:
Сообщение: Re: Why an array in pg_group?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: elog(PANIC) should abort()?