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

Re: COPY view

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Hans-Juergen Schoenig <hs(at)cybertec(dot)at>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>, List pgsql-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: COPY view
Date: 2006-08-22 03:49:09
Message-ID: 200608220349.k7M3n9314727@momjian.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Jim C. Nasby wrote:
> On Wed, Jun 14, 2006 at 05:19:44PM -0400, Bruce Momjian wrote:
> > Hans-Juergen Schoenig wrote:
> > > Bruce Momjian wrote:
> > > >>I don't see why views should be special. Tables clearly should be 
> > > >>because we can open them directly.
> > > >>    
> > > >>
> > > >
> > > >Ah, I didn't think of that.  Good idea.  So we don't need this patch?
> > > >
> > > >  
> > > >
> > > 
> > > why do we agree on a patch, implement it and reject it then?
> > > would be easier to reject it before actually implementing it ...
> > > it is quite hard to explain to a customer that something is rejected 
> > > after approval - even if things are written properly ...
> > 
> > Agreed.  The problem with this patch is that originally we just wanted
> > views, and later the idea of putting a query in there was agreed on, so
> > the feature request has changed over time.
> 
> BTW, one argument for allowing dumping out of views is that it means
> they'd act more like tables; you just COPY viewname TO file.
> 
> Also, if copy from select doesn't make it into 8.2, then we should
> absolutely put this patch in, so that users at least have something they
> can use.

OK, based on this feedback, I am adding COPY VIEW to the patches queue.

-- 
  Bruce Momjian   bruce(at)momjian(dot)us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

Responses

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2006-08-22 04:02:38
Subject: Re: Open 8.2 items
Previous:From: Bruce MomjianDate: 2006-08-22 03:40:42
Subject: Re: TODO: Add pg_get_acldef(),

pgsql-patches by date

Next:From: Bruce MomjianDate: 2006-08-22 03:49:23
Subject: Re: COPY view
Previous:From: Bruce MomjianDate: 2006-08-22 03:47:25
Subject: Re: SQL/XML publishing function experimental patch

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