Skip site navigation (1) Skip section navigation (2)

Re: PgAdmin problem

From: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
To: "Agrawal, Manish" <MAgrawal(at)coba(dot)usf(dot)edu>
Cc: 'Frankie Lam' <frankie(at)ucr(dot)com(dot)hk>,"'pgsql-interfaces(at)postgresql(dot)org'" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: PgAdmin problem
Date: 2003-02-19 13:59:36
Message-ID: Pine.LNX.4.21.0302191356020.2991-100000@ponder.fairway2k.co.uk (view raw or flat)
Thread:
Lists: pgsql-interfaces
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


In response to

pgsql-interfaces by date

Next:From: Mike AlfordDate: 2003-02-19 17:24:45
Subject: ECPG include problem
Previous:From: Agrawal, ManishDate: 2003-02-19 13:49:59
Subject: Re: PgAdmin problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group