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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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 Content-Type Size
create_replace_view-7.patch text/x-patch 28.6 KB

In response to

Responses

Browse pgsql-patches by date

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