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

Re: updating on views

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: XiaojingLi <iamlxj(at)163(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: updating on views
Date: 2002-11-27 02:20:23
Message-ID: 20021126180321.R85731-100000@megazone23.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Wed, 27 Nov 2002, XiaojingLi wrote:

> 	I'd like to bother you with something about updating views. At
> present, postgresql7.3doesn't support update on views.When I look up

It does if you provide the rules for what it means to do the update (and
there are some wierd issues with delete, but it is possible to get around
them)

> 	In my eyes, it is not very difficult to realize view update with
> fill the above three functionsBut I know the developers of
> postgresql are very learned, now that they didn't realize view update,
> maybe it is very difficult. I am a beginner of postgresql, so with my
> limited knowlege, maybe I can't realize the difficulity of doing such
> a thing. So I wonder if some of you would like to give me some advice
> about updating on views or why it is not realizedwhat's the
> difficulty of doing it?

Well, it depends.  SQL updatable views are fairly limited from what I
remember and the general write your own update rules is much broader, so I
doubt anyone got terribly excited by doing the limited version. It would
take some work to define what sort of view queries are acceptable for what
sort of updates and then make the appropriate rules (imagine queries with
set value functions or UNION) without knowledge outside of the view query.



In response to

Responses

pgsql-hackers by date

Next:From: David WheelerDate: 2002-11-27 02:35:08
Subject: Re: [HACKERS] Request from eWeek for 7.3 comments
Previous:From: Tom LaneDate: 2002-11-27 01:39:56
Subject: Re: elog(PANIC) should abort()?

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