> > > This would be a potential feature of being able to insert into
> views
> > > in general. Reversing the CREATE VIEW statement to accept
> inserts,
> > > deletes and updates.
> > Definitely not a 'potential' feature, but a existing and
documented
> one.
> > Read up on rules, especially 'ON INSERT DO INSTEAD' stuff. Its not
> > automatic, though.
>
> Trust me, I know how to go about doing those kinds of things
manually.
> I was referring to the automated reveral -- which creates this
> features in a very simple manner without any additions or changes to
> system tables -- aside from reverse rules themselves which is a more
> generic feature.
Hmm. My above statement lost all credibility in poor grammer and
speeling. Time for bed I suppose.
Anyway, the point is that some of the simple views should be straight
forward to reversing automatically if someone has the will and the
time it can be done. A while back a list of 'views which cannot be
reversed' was created and included things such as Unions,
Intersections, exclusions, aggregates, CASE statements, and a few more
items.
