On Fri, 2004-07-30 at 09:17, Secrétariat wrote:
> Hello !
> Why can't I update data when I use a VIEW instead of a TABLE ?
Because a view is not a table. Many views are inherently non-updatable,
and the backend assumes that all are.
> How can I do similar action ?
Create a rule on the view to update the base table(s) instead.
In response to
- Using view at 2004-07-30 08:17:20 from Secrétariat
pgsql-general by date
|Next:||From: Nilabhra Banerjee||Date: 2004-07-30 09:37:51|
|Subject: Postgresql and OS cluster|
|Previous:||From: Mage||Date: 2004-07-30 08:33:23|
|Subject: Re: Using view|