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
I think there are other issues with updateable views from MSAccess though.
Nigel J. Andrews
In response to
pgsql-interfaces by date
|Next:||From: Mike Alford||Date: 2003-02-19 17:24:45|
|Subject: ECPG include problem|
|Previous:||From: Agrawal, Manish||Date: 2003-02-19 13:49:59|
|Subject: Re: PgAdmin problem|