Re: about view - Mailing list pgsql-hackers

From Jan Wieck
Subject Re: about view
Date
Msg-id 3EBA6FF1.A09FAA17@Yahoo.com
Whole thread Raw
In response to about view  (yuezh@ccermail.net)
List pgsql-hackers
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 #



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: CIDR in pg_hba.conf
Next
From: Andrew Sullivan
Date:
Subject: Re: CIDR in pg_hba.conf