Re: Proposal for SYNONYMS

* elein (elein(at)varlena(dot)com) wrote:
> On Thu, Mar 09, 2006 at 04:42:43PM -0500, Jonah H. Harris wrote:
> > Not a whole lot actually. If we had updateable views, I'd suggest that people
> > change their create synonym syntax to create view. However, it would take
> > substantially more work to implement updatable views than synonyms and the
> > functionality of updatable views is substantially different than the use of
> > synonyms alone. If/when updatable views are implemented, I wouldn't have a
> > problem switching create synonym to actually create a view.
>
> Since updateable views are relatively easy to construct using rules
> I'm not sure an entire new syntax is necessary.

They're not all that easy to construct and they require constant
maintenance. If they're not maintained and the underlying table changes
in some way they can end up doing the wrong thing and causing suprises.

Thanks,

Stephen