Still can not update views in postgresql ?
Is it difficult to implement updating view ?

Thanks.


-----------------------------------------------------------
High Quality FREE Mail System For Economist 
http://www.ccermail.net/ 

China Center for Economic Research 
http://www.ccer.edu.cn/ 

China Economic Network 
http://www.cenet.org.cn/ 

High Quality Mail System @CCERMAIL? Powered by 3R Soft, Inc.
-----------------------------------------------------------







Still can not update views in postgresql ?
Is it difficult to implement updating view ?

Thanks.


-----------------------------------------------------------
High Quality FREE Mail System For Economist 
http://www.ccermail.net/ 

China Center for Economic Research 
http://www.ccer.edu.cn/ 
China Economic Network 
http://www.cenet.org.cn/ 

High Quality Mail System @CCERMAIL? Powered by 3R Soft, Inc.
-----------------------------------------------------------
Wed, 7 May 2003 10:59:43 +0800
yuezh@ccermail.net
=?gb2312?B?YWJvdXQgdmlldyA=?=
yuezh@ccermail.net wrote:
> 
> Still can not update views in postgresql ?
> Is it difficult to implement updating view ?

Yes, we have yet not implemented the automatic creation of INSERT,
UPDATE and DELETE rules for simple views. 

AFAIK the SQL standard defines those updatable views only for simple,
one table views without subselects and so forth ... should be easy
enough to define those rewrite rules by hand.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


Thu, 08 May 2003 10:55:45 -0400
Jan Wieck <JanWieck@Yahoo.com>
Re: about view 