Re: Updateable views... - Mailing list pgsql-hackers

From Eric D Nielsen
Subject Re: Updateable views...
Date
Msg-id 200303051539.KAA24120@nerd-xing.mit.edu
Whole thread Raw
In response to Re: Updateable views...  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Updateable views...
Re: Updateable views...
Re: Updateable views...
List pgsql-hackers
> Gavin Sherry <swm@linuxworld.com.au> writes:
> > I haven't had time to look into it further, but it occurs to me that
> > handling views which rely on joins would be far from trivial.
> 
> Views containing joins would not be updatable; problem solved. 

I see how that is what the spec says, but aren't the majority of joins that
people use/want to update a join of some type?  I thought that SQL99 allowed
updating view created by joins.

In either case is this a place where "exceeding" the spec would be a good 
thing or a bad thing?

Eric


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] Non-colliding auto generated names
Next
From: Tom Lane
Date:
Subject: Re: Updateable views...