Skip site navigation (1) Skip section navigation (2)

updating on views

From: "XiaojingLi" <iamlxj(at)163(dot)com>
To: pgsql-hackers(at)postgresql(dot)org <pgsql-hackers(at)postgresql(dot)org>
Subject: updating on views
Date: 2002-11-27 01:37:20
Message-ID: 20021127013628.B5B6C1D145CC3@sm204.163.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Hi!
	
	I'd like to bother you with something about updating views. At present, postgresql7.3 doesn't support update on views.When I 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 NOTYET
	RuleStmt   *replace_rule;
	RuleStmt   *append_rule;
	RuleStmt   *delete_rule;
#endif
.. ...

#ifdef NOTYET
	replace_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 developers of postgresql are very learned, now that they didn't realize view update, maybe it is very difficult. I am a beginner of 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 the difficulty of doing it?

    Long for your reply.
	Thank you!

Best regards!


	

        
 				

        Yours XiaojingLi
        qqjasmine(at)hotmail(dot)com
          2002-11-23




Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2002-11-27 01:39:56
Subject: Re: elog(PANIC) should abort()?
Previous:From: snpeDate: 2002-11-27 01:36:19
Subject: Re: Why an array in pg_group?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group