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.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
