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

Re: Using view

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Secrétariat <ets(at)rolland-fr(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Using view
Date: 2004-07-30 13:04:16
Message-ID: 20040730055650.C34403@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-general
On Fri, 30 Jul 2004, [iso-8859-1] Secrtariat wrote:

> Why can't I update data when I use a VIEW instead of a TABLE ?
> How can I do similar action ?

We require explicit rules to be made for updating the view.  Technically
there's a very small set of views for which we would need to make the
rules automatically to be spec complient, but those views are really
limited, IIRC, no joins, no group by, no set functions, no aggregates, and
some other limitations.  It'd be nice to be able to handle more
complicated cases automatically, but it's non-trivial.


In response to

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

pgsql-general by date

Next:From: Bruno Wolff IIIDate: 2004-07-30 15:34:11
Subject: Re: 7.2 - 7.4.2 production server migration issue
Previous:From: Christophe MusielakDate: 2004-07-30 12:32:02
Subject: 7.2 - 7.4.2 production server migration issue

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