pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Bernd Helmle <mailings@oopsware.de>
To: Jaime Casanova <jcasanov@systemguards.com.ec>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-hackers@postgresql.org
Subject: Re: WIP: Automatic view update rules
Date: Fri, 09 Jan 2009 17:53:31 +0100
Message-ID: <3B3B2ACA2DB4AF9AF585FBAF@teje> (raw)
In-Reply-To: <E8182FB470BA1207E6A8838D@teje>
References: <2849137C693B65CC8E86411C@imhotep.credativ.de>
	<94CF655A8D0DC7D5B4B81D8B@imhotep.credativ.de>
	<603c8f070811112006q906b3a6o59a66228b7fc997@mail.gmail.com>
	<7F84532C73CB3279DE8436E0@imhotep.credativ.de>
	<603c8f070811131344n5c087057p11f94780dae80885@mail.gmail.com>
	<603c8f070811252043r75db3e83v2eba1611452ee62e@mail.gmail.com>
	<EB911BE7EC3A7A599A379DEF@teje>
	<D0935A35C6F4B274E0CD4DDB@teje>
	<3073cc9b0812250943x23547116ud956d8ab111e55bf@mail.gmail.com>
	<61043.91.48.33.48.1230474598.squirrel@tooney.at.xencon.de>
	<E8182FB470BA1207E6A8838D@teje>

--On Freitag, Januar 09, 2009 13:20:57 +0100 Bernd Helmle 
<mailings@oopsware.de> wrote:

> That means, View1 consists of View2 and so on. What happens now if
> someone is going to change View3, so that it's not updatable anymore?
> What the patch actually does is, scanning all relations/views involved in
> a current view (and cascading updates) und reject update rules as soon as
> it finds more than one relation within a view definition. Unfortunately
> this seems not to be enough, we had really check all involved views for
> updatability recursively. The infrastructure for this is already there,
> but i wonder if it could be made easier when we are going to maintain a
> separate is_updatable flag somewhere in the catalog, which would make
> checking the relation tree for updatability more easier.

I've decided to check updatability of all involved views during view 
creation. Please find attached a new version with all other open issues 
adressed.

-- 
  Thanks

                    Bernd

Attachments:

  view_update.patch.bz2 (application/octet-stream, 12.0K) download

view thread (27+ messages)  latest in thread

Message-ID: <3B3B2ACA2DB4AF9AF585FBAF@teje>
Permalink:  ../3B3B2ACA2DB4AF9AF585FBAF@teje/
Also on:    postgresql.org/message-id/3B3B2ACA2DB4AF9AF585FBAF@teje

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: mailings@oopsware.de, jcasanov@systemguards.com.ec, robertmhaas@gmail.com
  Subject: Re: WIP: Automatic view update rules
  In-Reply-To: <3B3B2ACA2DB4AF9AF585FBAF@teje>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox