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

From Rod Taylor
Subject Re: Updateable views...
Date
Msg-id 1046880721.19527.10.camel@jester
Whole thread Raw
In response to Re: Updateable views...  (Eric D Nielsen <nielsene@MIT.EDU>)
List pgsql-hackers
On Wed, 2003-03-05 at 10:39, Eric D Nielsen wrote:
> > 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?

Lets try to meet the spec first, then debate about whether extending it
is a good or bad thing :)

--
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: [PATCHES] Non-colliding auto generated names
Next
From: Curt Sampson
Date:
Subject: Re: Updateable views...