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

Re: create or replace rule/view (fwd)

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Rod Taylor <rbt(at)zort(dot)ca>,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-09-01 22:15:17
Message-ID: 200209012215.g81MFH524992@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-patches
Your patch has been added to the PostgreSQL unapplied patches list at:

	http://207.106.42.251/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

---------------------------------------------------------------------------


Neil Conway wrote:
> 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, skipping... ]

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-patches by date

Next:From: Bruce MomjianDate: 2002-09-01 22:36:00
Subject: Re: revised patch for PL/PgSQL table functions
Previous:From: Neil ConwayDate: 2002-09-01 19:30:11
Subject: Re: create or replace rule/view (fwd)

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