Postgres Pro
Downloads
Home   >   mailing lists

Thread: about view

about view

From
yuezh@ccermail.net
Date:
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.
-----------------------------------------------------------

Re: about view

From
Jan Wieck
Date:
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 #