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

Re: create or replace rule/view (fwd)

From: Neil Conway <neilc(at)samurai(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Rod Taylor <rbt(at)zort(dot)ca>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>,Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>,PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: create or replace rule/view (fwd)
Date: 2002-08-31 05:49:57
Message-ID: 87y9an4lx6.fsf@mailbox.samurai.com (view raw or flat)
Thread:
Lists: pgsql-patches
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> You can redefine the query that supports the view.  You cannot add,
> remove, rename, or change the datatypes of any columns of the view.

I've attached a revision of Gavin's patch that implements this
behavior (sorry it took so long, I've been busy with getting ready to
move into university). I also did some review of Gavin's code: updated
copyfuncs & equalfuncs, removed some superfluous function parameters,
fixed some indentation, and write some regression tests.

It probably still needs some review, however.

Cheers,

Neil

-- 
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC

Attachment: create_replace_view-7.patch
Description: text/x-patch (28.6 KB)

In response to

Responses

pgsql-patches by date

Next:From: Alvaro HerreraDate: 2002-08-31 05:52:59
Subject: Re: [HACKERS] pg_attribute.attisinherited ?
Previous:From: Joe ConwayDate: 2002-08-31 00:28:41
Subject: Re: revised patch for PL/PgSQL table functions

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