On Wed, 19 Feb 2003, Agrawal, Manish wrote:
> 3. Also, updatable views would make Postgresql so much easier to use.
>
> The reason I ask is that if that were the case, PostgreSQL would be
> enormously popular beyond expectations. At the very least, introductory
> database courses in business schools could so easily use PostgreSQL instead
> of MS Access.
Views are updateable. You need to
CREATE RULE blah AS ON UPDATE TO myview DO INSTEAD UPDATE mytable SET acol = NEW.acol
for example.
I think there are other issues with updateable views from MSAccess though.
--
Nigel J. Andrews