Re: Using view - Mailing list pgsql-general

From Oliver Elphick
Subject Re: Using view
Date
Msg-id 1091178557.1562.9.camel@braydb
Whole thread Raw
In response to Using view  (Secrétariat <ets@rolland-fr.com>)
List pgsql-general
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.



pgsql-general by date:

Previous
From: Mage
Date:
Subject: Re: Using view
Next
From: "m.e.bruche@lse.ac.uk"
Date:
Subject: Moving tables between schemas