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

Re: Using view

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: Secrétariat <ets(at)rolland-fr(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Using view
Date: 2004-07-30 09:09:18
Message-ID: 1091178557.1562.9.camel@braydb (view raw, whole thread or download thread mbox)
Lists: 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.

In response to

  • Using view at 2004-07-30 08:17:20 from Secrétariat

pgsql-general by date

Next:From: Nilabhra BanerjeeDate: 2004-07-30 09:37:51
Subject: Postgresql and OS cluster
Previous:From: MageDate: 2004-07-30 08:33:23
Subject: Re: Using view

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